Bad Record Exception Issue Assignment
You must assign ports and priorities to data quality issues.
The following figure shows the Issue Assignment view:
The Issue Assignment view contains the following fields:
- Quality Issue
- Each quality issue port that you defined in the Quality Issues input group appears in the Quality Issue column.
- Input
- The Input column contains the data ports that you assign to quality issues in the Issue Assignment view. Associate an input port with each quality issue port. Each input port that contains bad quality data must have at least one corresponding quality issue port that indicates a type of issue. You might select the Phone_Number port for the Phone_Quality_Issue, for example. You can assign a port to more than one quality issue.
- Issue Priority
Issue priorities determine which quality issues are the most important when you assign the same input port to multiple quality issues. If more than one quality issue occurs for an input field, the Data Integration Service applies the highest priority quality issue. If more than one quality issue exists for an input port and the issues have the same priority, the Data Integration Service applies the topmost quality issue in the list. Enter a priority from 1 to 99, where 1 represents the highest priority.
Define issue priorities to filter the records in the Analyst tool.
Assigning Ports to Quality Issues
Assign a port to associate with each quality issue. The Developer tool creates ports in the Issues output group for each association that you add in the Issue Assignment view.
1. For each quality issue, click the Input field to display a list of input ports.
2. Select an input port to associate with the quality issue.
You can choose the same port for more than one issue.
3. Click the Issue column and select a priority for the quality issue.
