topic Re: Output reject not working in Talend Studio

Output reject not working

Parikhharshal — Sat, 16 Nov 2024 02:00:37 GMT

Hi Talend experts

I have got data into Redshift table which I am comparing with Salesforce and then finding ID which is not available in SF after comparison with table and delete them as an end goal.

While doing this I am using inner join reject to true and it still does not capture all the rejected IDs.

This is my job design and below is the config in second tmap

Am I doing something wrong?

Thanks

Harshal.

Re: Output reject not working

manodwhb — Wed, 01 Jul 2020 15:03:17 GMT

@Parikhharshal . Inner join reject will give the reject records from the Main table, not lookup table. since you are trying to take from lookup, if you want to take the rejects from lookup shuffle Main to lookup and lookup to main.

Re: Output reject not working

manodwhb — Wed, 01 Jul 2020 15:03:17 GMT

Re: Output reject not working

Parikhharshal — Wed, 01 Jul 2020 22:54:21 GMT

@manodwhb Yes that's right.

That's what I had done and it did wonders. Thanks.

Re: Output reject not working

Parikhharshal — Wed, 01 Jul 2020 22:54:21 GMT

@manodwhb Yes that's right.

That's what I had done and it did wonders. Thanks.