Accelerator Guide

10.4.0
- 10.5.4
- 10.5

Back Next

U.S./Canada Matching and Deduplication Rules

Use the matching and deduplication rules to measure the levels of similarity between the records in data sets.

Find the matching and deduplication rules in the following repository location:

[Informatica_DQ_Content]\Rules\Matching_Deduplication

The following table describes the matching and deduplication rules in the U.S./Canada accelerator:

Name	Description
mplt_CAN_IMO_Company_Name_and_Address_Match	Uses identity match strategies to identify duplicate rows in Canadian data based on company names and addresses. The mapplet generates group keys from the postal code data.
mplt_CAN_IMO_Familyname_and_Address_Match	Uses identity match strategies to identify duplicate rows in Canadian data based on family names and addresses. The mapplet generates group keys from the postal code data.
mplt_CAN_IMO_Individual_Name_and_Address_Match	Uses identity match strategies to identify duplicate rows in Canadian data based on person names and addresses. The mapplet generates group keys from the postal code data.
mplt_CAN_IMO_Personal_Name_and_Data_Match	Uses identity match strategies to identify duplicate rows in Canadian data based on person names and personal data. The fields in the personal data column should contain a single type of data, such as telephone number, email, or Social Insurance Number. The mapplet generates group keys from the personal data.
mplt_Company_Name_and_Address_Match	Uses field match strategies to identify duplicate rows based on company name and address data. The mapplet uses a combination of characters from the company name values and the postal code values to generate group keys.
mplt_Company_Name_Match	Uses field match strategies to identify duplicate rows based on company name. The mapplet generates Soundex codes from the company name values and uses the Soundex codes as group keys.
mplt_Familyname_and_Address_Match	Uses field match strategies to identify duplicate rows based on surname and address data. The mapplet uses a combination of characters from the surname values and the postal code values to generate group keys.
mplt_Firstname_and_SSN_Match	Uses field match strategies to identify duplicate rows based on first names and United States Social Security numbers. The mapplet generates group keys from the Social Security number data.
mplt_Individual_Name_and_Address_Match	Uses field match strategies to identify duplicate rows based on person names and United States address data. The mapplet uses a combination of characters from the surname values and the postal code values to generate group keys.
mplt_Individual_Name_and_Date_Match	Uses field match strategies to identify duplicate rows based on person names and date data. The mapplet generates group keys from the date data.
mplt_Individual_Name_and_Email_Match	Uses field match strategies to identify duplicate rows based on person names and email addresses. The mapplet generates group keys from the email address data.
mplt_Individual_Name_and_Phone_Match	Uses field match strategies to identify duplicate rows based on person names and telephone numbers. The mapplet generates group keys from the telephone number data.
mplt_Individual_Name_and_SSN_Match	Uses field match strategies to identify duplicate rows based on person names and United States Social Security numbers. The mapplet generates keys generated from the Social Security number data.
mplt_Individual_Name_Match	Uses field match strategies to identify duplicate rows based on person names. The mapplet generates NYSIIS codes from the surname values and uses the NYSIIS codes as group keys.
mplt_USA_Address_Match	Uses field match strategies to identify duplicate rows in United States data based on United States address data. The mapplet generates group keys from the postal code data.
mplt_USA_IMO_Company_Name_and_Address_Match	Uses identity match strategies to identify duplicate rows in United States data based on company names and addresses. The mapplet generates group keys from the postal code data.
mplt_USA_IMO_Familyname_and_Address_Match	Uses identity match strategies to identify duplicate rows in United States data based on family names and addresses. The mapplet generates group keys from the postal code data.
mplt_USA_IMO_Individual_Name_and_Address_Match	Uses identity match strategies to identify duplicate rows in United States data based on person names and addresses. The mapplet generates group keys from the postal code data.
mplt_USA_IMO_Personal_Name_and_Data_Match	Uses identity match strategies to identify duplicate rows in United States data based on person names and personal data. The fields in the personal data column must contain a single type of data, such as telephone number, email, or Social Security number. The mapplet generates group keys from the personal data.
rule_Company_Name_and_Address_MatchScore	Generates a match score based on company names and United States address data.
rule_Company_Name_MatchScore	Generates a match score based on company names.
rule_Familyname_and_Address_MatchScore	Generates a match score based on surnames and United States address data.
rule_Firstname_and_SSN_MatchScore	Generates a match score based on first names and United States address data.
rule_Individual_Name_and_Address_MatchScore	Generates a match score based on person names and United States address data.
rule_Individual_Name_and_Date_MatchScore	Generates a match score based on person names and dates.
rule_Individual_Name_and_Email_MatchScore	Generates a match score based on person names and email addresses.
rule_Individual_Name_and_Phone_MatchScore	Generates a match score based on person names and telephone numbers.
rule_Individual_Name_and_SSN_MatchScore	Generates a match score based on person names, Social Security numbers, and identification data.
rule_Individual_Name_MatchScore	Generates a match score based on person names.
rule_USA_Address_MatchScore	Generates a match score based on United States address data.

Rename Saved Search

Table of Contents

Accelerator Guide

Accelerator Guide

U.S./Canada Matching and Deduplication Rules

U.S./Canada Matching and Deduplication Rules