Looking for references on how to implement an audit framework in the Informatica ETL process in IDQ Developer.
Our aim is to capture the details of a record that does not meet a given business rule. The information to be captured by this framework - the column that failed the rule, the reason for rejecting it among others like a unique identifier of this record, job name (mapping/workflow) that had this rule, time when this job executed and the record was rejected.
The answer to your question would apply to any ETL tool.
Most important part is adding tables/fields to your db design tailored to satisfy the needs.
Once this design is completed it is just a matter of adding the needed logic to your existing ETL logic.