When you configure a workflow that contains an Exception transformation, you include the mapping in a Mapping task. You add a Human task to the same workflow. The Human task requires one or more users to correct the exception records in the Analyst tool.
The Mapping task identifies the records in the source data that contain unresolved data quality issues. Data analysts use the Analyst tool to resolve the issues and to update the data quality status of each record.
When you configure a Human task, you create one or more task instances and one or more task steps. A task instance represents the data set that a user must work on. A task step represents the type of work that a user performs on the records in his or her task instance. You can create multiple task instances so that different users work on different parts of the data in the Analyst tool.
A user can update the status of the bad records in the Analyst tool in one of the following ways:
If a record is valid, the user updates the table metadata to confirm the record for persistent storage in the database.
If a record is not valid, the user updates the table metadata to remove the record from the database at a later stage in the workflow.
If the record status is not confirmed, the user updates the table metadata so that the record returns to the workflow for further processing in a Mapping task.