The Bad Records table contains the exceptions with record scores between the lower and upper thresholds.
The following figure shows the bad records that the Exception transformation returns:
The Bad Records table includes all of the fields in the source record. A bad record also includes the following fields:
Workflow_ID
The name of the workflow that included the Exception transformation. The workflow contains the Exception transformation Mapping task and the Human task to review the issues. The Workflow_ID contains
DummyWorkflowID
if the Exception transformation is not in a workflow .
Row_Identifier
A unique number that identifies each row.
Record_Status
A record status for the Analyst tool. Each record in the Bad Records table receives an
Invalid
status. You can maintain the record status when you update records in the Analyst tool.