Informatica skipped records need to be written to bad files

Question

In my case, i have an expression transformation which uses the default function ERROR('transformation') to skip the records in which date value coming inside is not in the correct format. In this, the skipped rows are not written to the reject files, so that we are getting the reconcilation problem. I need the skipped rows to be written to the bad files.Please help me how can i achieve this.

Answer 1

Put the Update Strategy transformation in your mapping and flag these rows for reject (use the DD_REJECT constant).