Output reject not working

[Parikhharshal]

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.

[manodwhb]

@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.

[manodwhb · Accepted solution]

@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.

[Parikhharshal]

@manodwhb  Yes that's right. 

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

[Parikhharshal]

@manodwhb  Yes that's right. 

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