topic Re: How to achieve Right Outer Join functionality in Talend in Talend Studio

How to achieve Right Outer Join functionality in Talend

Anonymous — Sat, 16 Nov 2024 10:22:28 GMT

1. I need to join two tables Table1 and Table2.
2. Table1 is main and table2 is lookup table.
3. Table1 key will be matched to table2 column and Output will be rows from Table2 which do not have matching data.
So, I need to implement Right join functionality for this scenario. Any help would be appreciated.
Regards,
Jatin Singla

Re: How to achieve Right Outer Join functionality in Talend

Anonymous — Thu, 22 Sep 2016 06:58:58 GMT

Hi
Make table2 as main, table1 as lookup, do an inner job and get the unmatched rows. Please take a look at this article
https://help.talend.com/pages/viewpage.action?pageId=190513450
Regards
Shong

Re: How to achieve Right Outer Join functionality in Talend

Anonymous — Thu, 22 Sep 2016 08:24:27 GMT

Shong, Thanks for your reply.
But in my case table1 is an output from another tMap component which send id column data directly to another tMap component. So can't switch table2 as main input to component
Also tried to get id's in list component but new value overwrites old values and I was left with one id value instead of multiple rows.
Hope this will make it clear.
Regards,
Jatin Singla

Re: How to achieve Right Outer Join functionality in Talend

Anonymous — Fri, 23 Sep 2016 07:34:00 GMT

But in my case table1 is an output from another tMap component which send id column data directly to another tMap component. So can't switch table2 as main input to component

You can cache the output to memory first, and read the output from memory many times if neeeded later.
table1 output---main--tHashOutput
|
onsubjobok
|
table2--main--tMap (do inner join to get unmatched rows)
|
thashinput(read data from table1 output)
|
onsubjobok
|
other processing
Regards
Shong