Developer Transformation Guide

Back Next

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.