Exception Transformation
Effective in version 9.5.0, you can connect the bad record and duplicate record output from an Exception transformation to a data object in a mapping. You use the transformation to create the bad record and duplicate record tables and the data object.
Previously, you used the Exception transformation to write data to bad record or duplicate record tables that are not represented as repository objects.
If you upgrade to Data Quality 9.5.0 and the Model repository contains an Exception transformation, complete the following steps to use the transformation in Data Quality 9.5.0:
- 1. Create a data object from the database table that contains the bad records or duplicate records.
- 2. Add the data object to the mapping canvas.
- 3. Connect the bad data or duplicate data ports output ports to the data object.
When you run a mapping with an Exception transformation in Data Quality 9.5.0, you can use Informatica Analyst or Informatica Data Director for Data Quality to review and edit the table records.