CODEWITHSUNDEEP
informaticainformatica-powercenter
user2827693
user2827693

Reputation: 1

Informatica skipped records need to be written to bad files

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.

Upvotes: 0

Views: 5591

Answers (2)

Christian Brabandt
Christian Brabandt

Reputation: 8248

Well, don't use the abort() function then. Use a router to write the bad formated dates to a different target then.

Upvotes: 1

Marek Grzenkowicz
Marek Grzenkowicz

Reputation: 17353

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

More information: Update Strategy Transformation

Upvotes: 2

Related Questions