Configuring a Bad Record Exception Transformation

1. Create a reusable or a nonreusable Bad Record Exception transformation.
• - To create a reusable transformation, select File > New > Transformation and select a Bad Record Exception transformation.
• - To create a nonreusable transformation, open a mapping and add an Exception transformation to the mapping canvas. Select a Bad Record Exception transformation from the wizard.
2. Click Next, or click Finish.
If you click Next, you can update the default threshold values and the data routing options before you create the transformation.
3. Configure the input ports.
• - If you create a reusable transformation, select the Ports tab, and add ports for the data you want to connect to the transformation.
• - If you create a nonreusable transformation, add other objects to the mapping canvas and drag input ports to the transformation.
4. Select the Configuration view.
5. Configure the upper and lower score thresholds.
6. In the Data Routing Optionssection, configure the standard output and exception table properties to set where the transformation writes each type of record.
Configure where to write the Good Records, Bad Records, and Rejected Records. You can write them to standard output or to the Bad Records table.
7. Open the Issue Assignment view. Assign data quality issues to the data ports.
Assign a priority to each issue. If a port contains values with multiple issues, the transformation displays the top priority issue.
8. Select the option to generate a bad records table. Enter the database connection and table name information. The table must come from the default schema.
• - When you generate a bad records table, you generate a table for the records and an additional table for the data quality issues that relate to the records. The transformation creates a database object in the Model repository.
9. Connect the transformation output ports to one or more data targets. Connect the output ports to the data objects that correspond to the output options you set on the Configuration view.
• - If you create a reusable transformation, add the transformation to a mapping and connect the output ports.
• - If you create a nonreusable transformation, the transformation connects the ports to the bad record table. You connect output ports to any other data target.