A Bad Record Exception transformation has separate input groups for the data, the quality issues, and the record score.
The Bad Record Exception transformation has the following input groups:
Data
The source data fields.
Quality Issues
Contains ports that describe record quality problems. Quality issue ports contain strings such as "Excess_Characters" or "Bad_Data_Format." You can have multiple quality issues in each record. The transformation does not associate ports in the Quality Issues group to source data fields until you assign the issues to data ports in the
Issue Assignment
view.
Control
The record score. The Exception transformation analyzes the record score to determine if input rows are exceptions. If you do not connect the Score port, the Exception transformation identifies a row as an exception if a Quality Issues port contains data.