When you configure a Bad Record Exception transformation, configure the input ports and the quality issues that can occur in each port. Define the upper and lower thresholds for determining data quality. Configure where to write the exceptions and the reject records.
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.
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.
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.
Select the
Configuration
view.
Configure the upper and lower score thresholds.
In the
Data Routing Options
section, 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.
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.
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.
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.
ASK INFAPreview
