Creating a Duplicate Record Exception Transformation
When you configure a Duplicate Record Exception transformation, configure the input ports. Define the upper and lower thresholds for determining matches. Configure where to write the duplicate records and the unique records.
1. Create a reusable or a nonreusable Duplicate Record Exception transformation.
- - To create a reusable transformation, select File > New > Transformation and select a Duplicate Record Exception transformation.
- - To create a nonreusable transformation, open a mapping and add the transformation to the mapping canvas. Select a Duplicate Record Exception transformation from the wizard.
2. Click Next, or click Finish.
If you click Finish, you can update the default threshold values and the data routing options before you create the transformation.
3. In the Configuration view, configure the upper and lower match score thresholds.
4. In the Data Routing Optionssection, configure the standard output and exception table properties to set where the transformation writes each type of record.
Optionally, modify where to write the duplicate records, duplicate records to review, and unique records.
5. Optionally, generate a unique records table. Enter the database connection and table name information for the new table. When you generate a unique records table, the transformation creates a database object in the Model repository.
6. Configure the input ports. When you add an input port, the Developer tool adds the same port name to the output groups.
- - If you create a reusable transformation, select the Ports tab, and add ports for the data you want to connect to the transformation.
- - If you create a nonreusable transformation, add other objects to the mapping canvas and drag input ports to the transformation.
7. Connect the transformation output ports to one or more data targets. Connect the output ports to the data objects that correspond to the output options you set on the Configuration view.
- - If you create a reusable transformation, add the transformation to a mapping and connect the output ports.
- - If you create a nonreusable transformation, the transformation connects the ports to the Cluster Data table. You must connect output ports to the other data targets.