Left outer join

[akumar2]

Hi everyone!!

I need to perform left outer join in talend and fetch only non- matching records from my main table not from my look-up table. Like

Select a.* From resourcecopublishermapping a

Left outer join resouremapping b

On a.resourcemaster_id = b.resourcemaster_id

Where b.resourcemaster_id is null.

Can anyone help how to achieve the above scenario in talend using tmap. I have tried using filter condition on output side. But didn't get expected results.

Thanks in advance.

[Anonymous · Accepted solution]

Hi @arun kumar​ 

From you description, it seems like you want to do an inner join, and catch the inner join reject, the reject output contains the non-matching records from the main table.

 

Regards

Shong

[akumar2]

@Shicong Hong​ 

Hi @Shicong Hong​  tried inner join reject and got expected result. Thankyou.