topic Re: Not able to capture Inner Join Reject in Talend Studio

Not able to capture Inner Join Reject

ankit7359 — Tue, 11 Sep 2018 10:23:14 GMT

I m trying a scenario for inner join but i want to capture the inner join rejects as well. Can anyone help me on this... its bit urgent.

Re: Not able to capture Inner Join Reject

TRF — Tue, 11 Sep 2018 10:33:42 GMT

Your "InnerJoinReject" flow cannot be populated by row2 records as soon as they are not retrieved by the inner join.

You can only use row1 data to populate this flow.

This is logic, isn't it?

Re: Not able to capture Inner Join Reject

Anonymous — Tue, 11 Sep 2018 10:37:06 GMT

Hi,

As per your screenshot you haven't changed the join to Inner join at source side where the join happens.By default talend does Left Outer Join.So please change it to Inner Join and then rerun the job.You will get the desired output

Thanks,

Kiran

Re: Not able to capture Inner Join Reject

manodwhb — Tue, 11 Sep 2018 10:39:20 GMT

@ankit7359,as @TRF said,you can capture the rejects from the Main input table not from the lookup table. An tMap will support default as leftouter,that you need to change to inner in join model option