You create a workflow and you add a Start event and End event.

You create a mapping

Mapping_1

that examines a data set for duplicate records. The mapping contains an Exception transformation that writes good-quality records to a database table named

Good_Records

and writes exceptions to a table named

Exceptions

.

You add a Mapping task to the workflow, and you configure the task to run

Mapping_1

.

You add a Human task to the workflow, and you configure the task to assign the data in the

Exceptions

table to users.

You configure a mapping

Mapping_2

to read the

Exceptions

table and to write records to the

Good_Records

table if the Human task updated the record with an Approved status.

You add a second Mapping task to the workflow, and you add

Mapping_2

to the Mapping task.

You configure a Notification task to send an email message to selected users. The email message states that the second Mapping task is complete.

You connect the events and tasks in the workflow.