Weighted Match Scores Example
You create a match analysis mapping to determine the number of duplicate customer names in a customer database. You add two Comparison transformations to generate match scores for the ZIP code and Surname columns in the data set.
Many records have matching ZIP codes, but a much smaller number of records have matching surnames. When averaging these match scores, you need to emphasize the importance of the more unique matches.
To emphasize the importance of the surname match scores, you apply a higher weight to the Surname match score.
For example, you set the Weight value of the Surname score input to 0.8, and you set the value of the Weight value of the ZIP Code score input to 0.4.