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 Contact Data Cleansing Rules

Australia/New Zealand Contact Data Cleansing Rules

Use the contact data cleansing rules to parse, standardize, and validate data about business contacts and individuals.
Find the contact data cleansing rules in the following repository location:
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
The following table describes the contact data cleansing rules in the Australia/New Zealand accelerator:
Name
Description
rule_AUS_Driver_Licence_Number_Validation
Validates Australian driver's license numbers based on length and pattern requirements.
rule_AUS_Gender_Assignment
Assigns gender according to first names. The rule returns "M" for male names, "F" for female names, and "U" if the gender is unknown. For example, the rule assigns the name "John Smith" a gender of "M" for male.
rule_AUS_Given_Name_Standard
Generate given names from Australian nicknames.
rule_AUS_Multi_Person_Name_Parse
Parses person name values into separate ports. The rule creates ports for values such as title, first name, middle name, and surname.
The rule output includes a port that contains the full name of the person in the record. You can use the full name port as an input to a Match transformation in an identity match analysis mapping.
When the name data identifies more than one person, the rule creates an output port for each full name. For example, the rule can read the name "John and Jane Smith" and create output ports for "John Smith" and "Jane Smith."
rule_AUS_Personal_Name_Parsing_FML
Parses the values in a person name into separate ports.
The rule creates the ports in the following sequence:
  • First name, middle name, last name
The rule output also includes a port that contains the full name of the person in the record. You can use the full name port as an input to a Match transformation in an identity match analysis mapping.
rule_AUS_Personal_Name_Parsing_LFM
Parses the values in a person name into separate ports.
The rule creates the ports in the following sequence:
  • Last name, first name, middle name
The rule output also includes a port that contains the full name of the person in the record. You can use the full name port as an input to a Match transformation in an identity match analysis mapping.
rule_AUS_Phone_Number_Parse
Parses a Australian telephone number from a string. The rule parses the first telephone number in the data, reading from right to left.
The rule recognizes telephone numbers that use leading zeros, international dialing codes, or extensions that begin with the hash symbol. The rule processes the following punctuation symbols: the plus sign, parentheses, and the hash symbol. Before you run the rule, remove all other punctuation, including double spaces.
The rule returns a telephone number and also returns a string that contains the input text with the telephone number removed.
rule_AUS_Phone_Number_Standardization
Standardizes Australian telephone numbers to international and local dialing formats. The rule recognizes telephone numbers that use leading zeros, international dialing codes, or extensions that begin with the hash symbol.
rule_AUS_Phone_Number_Validation
Validates the area code and length of Australian telephone numbers. The rule returns the region of the telephone number, as well as codes that indicate if the area code and length of a telephone number are valid.
rule_AUS_Tax_File_Number_Parse
Parses Australian Tax File Numbers (TFN).
rule_AUS_Tax_File_Number_Standardization
Standardizes Australian Tax File Numbers (TFN). To configure the standardized format, edit the TFN_Format expression variable in the dq_Format_TFN Expression transformation. Default is "No_punctuation."
rule_AUS_Tax_File_Number_Validation
Validates Australian Tax File Numbers (TFN) based on the check digit in each number.
rule_NZL_Gender_Assignment
Assigns gender according to New Zealand first names. The rule returns "M" for male names, "F" for female names, and "U" if the gender is unknown. For example, the rule assigns the name "John Smith" a gender of "M" for male.
rule_NZL_Given_Name_Standard
Generate given names from New Zealand nicknames.
rule_NZL_IRD_Number_Parse
Parses nine-digit numeric strings as New Zealand Inland Revenue Department numbers (IRD).
rule_NZL_IRD_Number_Standardization
Standardizes New Zealand Inland Revenue Department numbers (IRD). To configure the standardized format, edit the IRD_Format expression variable in the dq_Format_IRD Expression transformation. Default is "No_punctuation." The rule requires that the input is a nine-digit string.
rule_NZL_IRD_Number_Validate
Validates New Zealand Inland Revenue Department numbers (IRD) based on the check digit in each number.
rule_NZL_Phone_Number_Parse
Parses a New Zealand telephone number from a string. The rule parses the first telephone number in the data, reading from right to left.
The rule recognizes telephone numbers that use leading zeros, international dialing codes, or extensions that begin with the hash symbol. The rule processes the following punctuation symbols: the plus sign, parentheses, and the hash symbol. Before you run the rule, remove all other punctuation, including double spaces.
The rule returns a telephone number and also returns a string that contains the input text with the telephone number removed.
rule_NZL_Phone_Number_Standardization
Standardizes New Zealand telephone numbers to international and local dialing formats. The rule recognizes telephone numbers that use leading zeros, international dialing codes, or extensions that begin with the hash symbol.
rule_NZL_Phone_Number_Validation
Validates the area code and length of New Zealand telephone numbers. The rule returns the region of the telephone number, as well as codes that indicate if the area code and length of a telephone number are valid.
rule_Prename_Assignment
Generates an honorific according to the gender. You can change the female_prename expression variable from Ms. to Mrs.
rule_Salutation_Assignment
Generates formal and casual greetings from prenames and name tokens. For example, when input data contains "Mr. John Smith," the rule generates the formal greeting "Dear Mr. Smith," and the casual greeting "Dear John,". You can change the prefix and punctuation by editing the variables in the dq_Generate_Salutation Expression transformation.

Dependencies on Core Contact Data Cleansing Rules

The Australia/New Zealand accelerator depends on the following contact data cleansing rules from the Core accelerator:
  • rule_Email_Validation
For more information about these rules, see OOTB Contact Data Cleansing Rules.