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

Australia/New Zealand Matching and Deduplication Rules

Australia/New Zealand Matching and Deduplication Rules

Use the matching and deduplication rules in the Australia/New Zealand accelerator 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 Australia/New Zealand accelerator:
Name
Description
mplt_AUS_Firstname_and_TFN_Match
Uses field match strategies to identify duplicate rows in Australian data based on Tax File Numbers (TFN) and first names. The mapplet generates group keys from the TFN data.
mplt_AUS_IMO_Company_Name_and_Address_Match
Uses identity match strategies to identify duplicate rows for Australian data based on company names and addresses. The mapplet generates group keys from the postal code data.
mplt_AUS_IMO_Familyname_and_Address_Match
Uses identity match strategies to identify duplicate rows in Australian data based on family names and addresses. The mapplet generates group keys from the postal code data.
mplt_AUS_IMO_Individual_Name_and_Address_Match
Uses identity match strategies to identify duplicate rows in Australian data based on person names and addresses. The mapplet generates group keys from the postal code data.
mplt_AUS_IMO_Personal_Name_and_Data_Match
Uses identity match strategies to identify duplicate rows in Australian data based on person names and personal data. The fields in the personal data column must contain a single type of data, such as a telephone number, email, or Tax File Number. The mapplet generates group keys from the personal data.
mplt_AUS_Individual_Name_and_Address_Match
Uses field match strategies to identify duplicate rows based on person names and Australia address data. The mapplet uses a combination of characters from the surname values and the postal code values to generate group keys.
mplt_AUS_Individual_Name_and_Date_Match
Uses field match strategies to identify duplicate rows based on Australian person names and dates. The mapplet generates group keys from the date data.
mplt_AUS_Individual_Name_and_Email_Match
Uses field match strategies to identify duplicate rows based on email addresses and Australian person names. The mapplet generates group keys from the email address data.
mplt_AUS_Individual_Name_and_Phone_Match
Uses field match strategies to identify duplicate rows based on Australian person names and telephone numbers. The mapplet generates group keys from the telephone number data.
mplt_AUS_Individual_Name_and_TFN_Match
Uses field match strategies to identify duplicate rows for Australian data based on Tax File Numbers (TFN) and person names. The mapplet generates group keys from the TFN data.
mplt_AUS_Individual_Name_Match
Uses field match strategies to identify duplicate rows based on Australian person names. The mapplet generates NYSIIS codes from the surname values and uses the NYSIIS codes as group keys.
mplt_AUS_NZL_Company_Name_and_Address_Match
Uses field match strategies to identify duplicate rows based on company name and address data from Australia and New Zealand. The mapplet uses a combination of characters from the company name values and the postal code values to generate group keys.
mplt_AUS_NZL_Familyname_and_Address_Match
Uses field match strategies to identify duplicate rows based on surname and address data from Australia and New Zealand. The mapplet uses a combination of characters from the surname 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_NZL_Firstname_and_IRD_Match
Uses field match strategies to identify duplicate rows for New Zealand data based on Inland Revenue Department (IRD) numbers and first names. The mapplet generates group keys from the IRD number.
mplt_NZL_IMO_Company_Name_and_Address_Match
Uses identity match strategies to identify duplicate rows in New Zealand data based on company names and addresses. The mapplet generates group keys from the postal code data.
mplt_NZL_IMO_Familyname_and_Address_Match
Uses identity match strategies to identify duplicate rows in New Zealand data based on family names and addresses. The mapplet generates group keys from the postal code data.
mplt_NZL_IMO_Individual_Name_and_Address_Match
Uses identity match strategies to identify duplicate rows in New Zealand data based on person names and addresses. The mapplet generates group keys from the postal code data.
mplt_NZL_IMO_Personal_Name_and_Data_Match
Uses identity match strategies to identify duplicate rows in New Zealand 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 Inland Revenue Department number. The mapplet generates group keys from the personal data.
mplt_NZL_Individual_Name_and_Address_Match
Uses field match strategies to identify duplicate rows based on person names and New Zealand address data. The mapplet uses a combination of characters from the surname values and the postal code values to generate group keys.
mplt_NZL_Individual_Name_and_Date_Match
Uses field match strategies to identify duplicate rows based on New Zealand person names and dates. The mapplet generates group keys from the date data.
mplt_NZL_Individual_Name_and_Email_Match
Uses field match strategies to identify duplicate rows based on email addresses and New Zealand person names. The mapplet generates group keys from the email address data.
mplt_NZL_Individual_Name_and_IRD_Match
Uses field match strategies to identify duplicate rows based on New Zealand person names and Inland Revenue Department (IRD) numbers. The mapplet generates group keys from the IRD number.
mplt_NZL_Individual_Name_and_Phone_Match
Uses field match strategies to identify duplicate rows based on New Zealand person names and telephone numbers. The mapplet generates group keys from the telephone number data.
mplt_NZL_Individual_Name_Match
Uses field match strategies to identify duplicate rows based on New Zealand person names. The mapplet generates NYSIIS codes from the surname values and uses the NYSIIS codes as group keys.
rule_AUS_NZL_Company_Name_and_Address_MatchScore
Generates a match score based on company names and addresses from Australia and New Zealand.
rule_AUS_NZL_Familyname_and_Address_MatchScore
Generates a match score based on surnames and addresses from Australia and New Zealand.
rule_AUS_NZL_Firstname_and_PID_MatchScore
Generates a match score based on first names and personal identification numbers.
rule_AUS_NZL_Individual_Name_and_Address_MatchScore
Generates a match score based on person names and addresses from Australia and New Zealand.
rule_AUS_NZL_Individual_Name_and_PID_MatchScore
Generates a match score based on person names and personal identification numbers.
rule_Company_Name_MatchScore
Generates a match score based on company names.
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_MatchScore
Generates a match score based on person names.

0 COMMENTS

We’d like to hear from you!