Table of Contents

Search

  1. Preface
  2. Introduction to Accelerators
  3. Core Accelerator
  4. Data Domains Accelerator
  5. Australia/New Zealand Accelerator
  6. BCBS 239/CCAR Accelerator
  7. Brazil Accelerator
  8. Financial Services Accelerator
  9. France Accelerator
  10. Germany Accelerator
  11. India Accelerator
  12. Italy Accelerator
  13. Portugal Accelerator
  14. Spain Accelerator
  15. United Kingdom Accelerator
  16. U.S./Canada Accelerator

Accelerator Guide

Accelerator Guide

United Kingdom Matching and Deduplication Rules

United Kingdom 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 United Kingdom accelerator:
Name
Description
mplt_GBR_Company_Name_Postcode_Match
Uses field match strategies to identify duplicate rows in United Kingdom data based on company name and postal code. The mapplet generates group keys from the postal code.
mplt_GBR_Familyname_and_NINO_Match
Uses field match strategies to identify duplicate rows in United Kingdom data based on surname and National Insurance Number (NINO). The mapplet generates group keys from the NINO data.
mplt_GBR_Familyname_and_Postcode_Match
Uses field match strategies to identify duplicate rows in United Kingdom data based on surname and United Kingdom postal code. The mapplet generates group keys from the postal code data.
mplt_GBR_Firstname_3CharsSurname_DOB_and_Postcode_Match
Uses field match strategies to identify duplicate rows in United Kingdom data based on the following data:
  • First name
  • The first three characters in the surname
  • Date of birth
  • postal code
The mapplet generates group keys from the postal code data.
mplt_GBR_Firstname_Surname_2ElementsDOB_and_Postcode_Match
Uses field match strategies to identify duplicate rows in United Kingdom data based on the following data:
  • Person names
  • Any two date of birth elements, such as month and year
  • United Kingdom postal code
The mapplet generates group keys from the postal code data.
mplt_GBR_Firstname_Surname_DOB_and_Postcode_Match
Uses field match strategies to identify rows based on the following data:
  • Person names
  • Date of birth
  • postal code
The mapplet generates group keys from the postal code data.
mplt_GBR_IMO_Company_Name_and_Address_Match
Uses identity match strategies to identify duplicate rows in United Kingdom data based on company names and addresses. The mapplet generates group keys from the postal code data.
mplt_GBR_IMO_Familyname_and_Address_Match
Uses identity match strategies to identify duplicate rows in United Kingdom data based on family names and addresses. The mapplet generates group keys from the postal code data.
mplt_GBR_IMO_Individual_Name_and_Address_Match
Uses identity match strategies to identify duplicate rows in United Kingdom data based on person names and addresses. The mapplet generates group keys from the postal code data.
mplt_GBR_IMO_Personal_Name_and_Data_Match
Uses identity match strategies to identify duplicate rows in United Kingdom 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 National Insurance Number. The mapplet generates group keys from the personal data.
mplt_GBR_Individual_Name_and_Date_Match
Uses field match strategies to identify duplicate rows in United Kingdom data based on person names and date data. The mapplet generates group keys from the date data.
mplt_GBR_Individual_Name_and_Email_Match
Uses field match strategies to identify duplicate rows in United Kingdom data based on person names and the email address data. The mapplet generates group keys from the email address data.
mplt_GBR_Individual_Name_and_NINO_Match
Uses field match strategies to identify duplicate rows in United Kingdom data based on person names and National Insurance Numbers (NINO). The mapplet generats group keys from the NINO data.
mplt_GBR_Individual_Name_and_Phone_Match
Uses field match strategies to identify duplicate rows in United Kingdom data based on person names and telephone numbers. The mapplet generates group keys from the telephone number data.
mplt_GBR_Individual_Name_and_Postcode_Match
Uses field match strategies to identify duplicate rows in United Kingdom data based on person names and the postal code data. The mapplet generates group keys from the postal code data.
mplt_GBR_Individual_Name_Match
Uses field match strategies to identify duplicate rows in United Kingdom data based on person names. The mapplet generates NYSIIS codes from the surname values and uses the NYSIIS codes as group keys.
rule_GBR_Familyname_and_NINO_MatchScore
Generates a match score based on surnames and United Kingdom National Identification Numbers (NINO).
rule_GBR_Familyname_and_Postcode_MatchScore
Generates a match score based on surnames and United Kingdom postal codes.
rule_GBR_Firstname_3CharsSurname_DOB_and_Postcode_MatchScore
Generates a match score based on the following information:
  • First name
  • The first three characters in the surname
  • Date of birth
  • Postal code
rule_GBR_Firstname_Surname_2ElementsDOB_and_Postcode_MatchScore
Generates a match score based on the following information:
  • Person names
  • Any two date of birth elements, such as month and year
  • United Kingdom postal code
rule_GBR_Firstname_Surname_DOB_and_Postcode_MatchScore
Generates a match score based on person names, date of birth, and postal code.
rule_GBR_Individual_Name_and_NINO_MatchScore
Generates a match score based on person names and United Kingdom National Insurance Numbers (NINO).
rule_GBR_Individual_Name_and_Phone_MatchScore
Generates a match score based on person names and telephone numbers.
rule_GBR_Individual_Name_and_Postcode_MatchScore
Generates a match score based on person names and United Kingdom postal codes.
rule_Individual_Name_and_Date_MatchScore
Generates a match score based on person names and dates.
rule_Individual_Name_MatchScore
Generates a match score based on person names.
rule_GBR_Company_Name_Postcode_MatchScore
Generates a match score based on company name and United Kingdom postal codes.
rule_Individual_Name_and_Email_MatchScore
Generates a match score based on person names and email addresses.