The exception data that an exception task job generates contains columns from the
source data set that the task reads and columns that the exception task creates at run time.
The columns that the job adds provide additional information about the task and how the job
identified the exceptions.
The exception task job creates the the following columns:
Row ID
Indicates the row number of the exception record in the source file.
A given record can appear more than once in an exception report in the following cases:
A rule specification found a data quality issue in
more than one input column in the record.
More than one rule specification identified a data quality issue in the record.
When more than one instance of a record appears in the exception report, each instance has
the same Row ID value.
Priority
Indicates the priority of the data quality issue that defines the record as an exception. The exception task reads the priority value from the rule specification that identifies the record as an exception.
Exception Message
Describes the data quality issue that defines the record as an exception. The exception task reads the exception message from the rule specification that identifies the record as an exception.
Rule Name
Contains the name of the rule specification that identifies the record as an exception.
Rule Input Columns
Identifies the columns of input data that the rule specification in the exception task analyzes.
Job ID
Contains a unique identifier for a particular job that you ran.
Creation Date
Contains the date on which you ran the exception job.
Dynamic renaming of duplicate field names
If the input data to the exception task contains a column with same name as a column that the
job adds to the exception data, the system renames the input column in the following
ways:
For the column names Row ID, Exception Message,
Rule Name, Rule Input Columns, and Creation Date, the system replaces the space
character in the input column name with an underscore. For example, the system
changes the name
Rule Input Columns
to
Rule_Input_Columns
.
For the column names Job ID and Priority, the
system appends an integer to the input column name. For example, the system
changes the name
ASK INFAPreview
