tMSSqlOutput "Rejects Link" not working?

APTOS — Tue, 19 Jan 2016 11:08:20 GMT

Hi, I 'm using Talend Open Studio for Data Integration v.6.1 and it seems that the reject link for the component tMSSqlOutput doesn't work properly.
The flow is the following: tFileInputExcel -> tMap -> tMSSqlOutput -(rejects)-> tFileOutputDelimited.

Primary Keys are specified.

By using the action "Insert if not exist" I expect the component tMSSqlOutput to reject all the rows which PKs are already present in the table, but it doesn't happen. Rows are not inserted nor updated, yet nothing passes the Rejects link and nothing gets written in the output file.

Any idea? Thanks.

Re: tMSSqlOutput "Rejects Link" not working?

Anonymous — Wed, 20 Jan 2016 06:07:53 GMT

Hi,
The rejects row is used to gather the data that does NOT match the filter or are not valid for the expected output. This link allows you to track the data that could not be processed for any reason (wrong type, undefined null value, etc.)
For your requirement, are you looking for the changed data?
It looks like:
targe DB-->tMap(Catch lookup inner rejected)-->output(to get the changed data)
source DB-->
Best regards
Sabrina

topic tMSSqlOutput "Rejects Link" not working? in Talend Studio

tMSSqlOutput "Rejects Link" not working?

Re: tMSSqlOutput "Rejects Link" not working?