Rejected rows into a bad file, how to avoid that when using Informatica

Question

I have developed an Informatica PowerDesigner 9.1 ETL Job which uses lookup and an update transform to detect if the target table has the the incoming rows from the source or not. I have set for the Update transform a condition

IIF(ISNULL(target_table_surrogate_id), DD_INSERT, DD_REJECT)

Now, when the incoming row is already in the target table, the row is rejected. Informatica writes these rejected rows into a .bad file. How to prevent this? Is there a way to determine that the rejected rows are not written into a .bad file? Or should I use e.g. a router insted of an update transform to determine if the row is insert row an then discard the other rows?

Answer 1

Identiffy the new or changed rows, which will be inserted/updateed.

Answer 2

If We uncheck option " Forward Rejected Rows " in update strategy transformation then rejected rows won't be logged into bad file.