The documentation portal is undergoing maintenance. During this period, you can't create any new user credentials. If you do, you'll need to recreate the user credential after the maintenance period ends.
Configure a Duplicate Record Exception mapping that examines customer records and finds duplicate records.
The following figure shows the Duplicate Record Exception mapping:
The mapping contains the following objects:
Customer_Details
The data source that might contain duplicate records.
mat_MatchData
A Match transformation that examines the customer data to determine if records match. The Match transformation creates a numeric score that represents the degree of similarity between two column values. An algorithm calculates a match score as a decimal value in the range 0 through 1. An algorithm assigns a score of one when two column values are identical.
exc_Consolidate
A Duplicate Record Exception transformation that determines which records are possible duplicate customers, known duplicate customers, or unique customer records.
Write_GoodMatches_Customer table
Table that receives all the records that do not need manual review. The Duplicate Record Exception transformation writes duplicate records and unique records to this table.
Target_CustomerConsolidate table
The Exception transformation writes the possible duplicate records to the Target_CustomerConsolidate table. Records in this table require manual review in the Analyst tool.