Problem join using tmap

Seven Stars

Problem join using tmap

Hi,

I try to join 2 tables from SQL Server in order to integrate the result in another table. Unfortunately, the join does not happen properly and the number of rows inserted in the table is only 472. 

I didn't understand the cause of the problem!

 

Please help me!

Best regards.   

C1.PNGc2.PNG

 
 
 
 
 

Accepted Solutions
Highlighted
Seven Stars

Re: Problem join using tmap

Thanks for all your replays. 

 

I think the problem was because doing the join with a key that contains multiple values (not unique) so I've modified my job in another way and it works.

 

Best regards


All Replies
Nine Stars

Re: Problem join using tmap

Hi,

 

What is the issue? You are joining based on Name field from both tables. What is the expected output?

 

Regards,

 

Veeru Boppudi
Seven Stars

Re: Problem join using tmap

Thanks for your replay.

The issues are : 

-Table 1(tmssqlInput1) contains data since 2018 and Table 2(tmssqlInput2) contains data from 2017.

The expected result is to have the join of the 2 tables (data since 2017 and 2018) by name but I got only the value from the table 1.

-In the screenshot, the number of lines inserted is 182753 while in the table it has only 400 line! 

Nine Stars

Re: Problem join using tmap

Do you have any errors in log?

 

Regards,

 

Veeru Boppudi
Seven Stars

Re: Problem join using tmap

Hi,

No nothing!

 

 

Four Stars

Re: Problem join using tmap


@INESBKwrote:

Thanks for your replay.

The issues are : 

-Table 1(tmssqlInput1) contains data since 2018 and Table 2(tmssqlInput2) contains data from 2017.

The expected result is to have the join of the 2 tables (data since 2017 and 2018) by name but I got only the value from the table 1.

-In the screenshot, the number of lines inserted is 182753 while in the table it has only 400 line! 


 

Possibility1 : You seem to want an inner join (the default for tMap is left outer)

 

Solution: If yes, change to inner: https://community.talend.com/t5/Design-and-Development/Doing-an-inner-join-using-a-tMap-component/ta...

 

Possibility 2:  You seem to want to catch rejects, so you can see count?

If yes, catch rejects (same link), so you can see how many has a.name <>b.name

 

Possibility 3: If you want data for both 2017+2018, are you using English word "join" to mean rdbms word "UNION"?

If yes, perhaps you've to find a way to "UNION"

 

Forteen Stars

Re: Problem join using tmap

since your join keys are defined properly means,what operation you define on data ?,might it has updated based on key columns.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Seven Stars

Re: Problem join using tmap

Thanks for all your replays. 

 

I think the problem was because doing the join with a key that contains multiple values (not unique) so I've modified my job in another way and it works.

 

Best regards

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch