topic Re: Left outer join in Talend Studio

Left outer join

akumar2 — Tue, 19 Dec 2023 01:53:47 GMT

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.

Re: Left outer join

Anonymous — Thu, 21 Dec 2023 08:14:29 GMT

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

Re: Left outer join

akumar2 — Thu, 21 Dec 2023 10:24:43 GMT

@Shicong Hong

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