Capture Informatica PowerCenter row errors into a flat file or database during runtime.
Informatica PowerCenter logs error in the session logs. In order to capture row data information related to the error into a flat file or database table during runtime you can enable row-level error logging.
In some cases enabling row-level error logging is not feasible as it disables block processing. You can then use the technique described in this solution to log errors and source data to a flat file or an error table.
Radhakrishna Sarma is an “ETL Specialist” in an Investment Bank in Singapore. Radha has got solid experience in Oracle & Informatica and is very proficient in these areas. He has made many contributions to both the Developers’ communities through many means like OTN, Devnet, personal blog etc. His contributions are remarkably known to the Informatica Developer community.