topic Re: tMap forwarding more rows than planned to tJavaRow in Talend Studio

tMap forwarding more rows than planned to tJavaRow

Anonymous — Mon, 02 Apr 2018 15:39:27 GMT

Hello,

I have 2 objects connecting to a tMap. For my test, I've created 3 records on main object A, and 2 on lookup object B. I've also linked a tJavaRow to my tMap to print the rows values. However, instead of getting 3 records, I'm getting 6 (3 from main object A times 2 from object B) :

How to I prevent that? i only want the 3 records from main object A, with related fields of object B. For example like this job:

Re: tMap forwarding more rows than planned to tJavaRow

vboppudi — Mon, 02 Apr 2018 15:57:43 GMT

Hi,

What is the join key in tMap?

If you are not using join key it will be cross join and you will get 2*3 records out.

Please post tMap configurations.

Regards,

Re: tMap forwarding more rows than planned to tJavaRow

TRF — Mon, 02 Apr 2018 16:31:13 GMT

You must have a common field between main object and each lookup object (probably the field used to establish the lookup relation between these objects).
Then you have to choose between inner or outer join model in tMap depending on what you expect.

Re: tMap forwarding more rows than planned to tJavaRow

Anonymous — Mon, 02 Apr 2018 16:45:19 GMT

Thanks a lot vboppudi.

A little nudge in the right direction was all that I needed. I configured a join key in my mapping, and it's working as it should now.

Re: tMap forwarding more rows than planned to tJavaRow

Anonymous — Mon, 02 Apr 2018 16:48:06 GMT

Thank you for your reply TRF. I already configured a join key as suggested by vboppudi. I marked his answer as the chosen answer, because he was the first to comment.

Thank you again.

Kind regards.