DSXchange

Hi All!

My job design looks like the below.

Dataset->T/R -->Db2-->(Rejectlink)Dataset.

Write Mode-->Insert
Table action-->Append
For the testing purpose we are processing some duplicate records and trying to collect the rejected records which are not able to insert in the DB2 table.
RCP is enabled because of using the same template we are populating more entities.So, we are not in the position to change our 'Write Mode' also.

The problem is we are not able to collect the rejected records from DB2 and the job getting aborted due to the unique key violation(dup records).
Please help us in data rejection.

Thanks in Advance......

Try using an exception table in a DB2 connector stage. It will automatically route the duplicate primary keys to the exception table.