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

Core Contact Data Cleansing Rules

Core Contact Data Cleansing Rules

Use the contact data cleansing rules to parse and validate data about business contacts and individuals.
Find the contact address 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 Core accelerator:
Name
Description
rule_Email_Parse
Parses email addresses from data fields.
rule_Email_Parse_and_Validate
Parses email addresses from data fields and validates the format of each email address.
rule_Email_Parse_Into_Mailbox_Domain
Parses email addresses into mailbox, domain, and subdomain ports. For example, the rule parses
info@informatica.com
in the following manner:
  • Mailbox: info
  • Subdomain: informatica
  • Domain: com
rule_Email_Validation
Validates the format of email addresses. The rule does not verify that the email addresses are accurate or active. The rule returns Valid or Invalid.
rule_Identify_Suspect_Names
Identifies names that might not be genuine person names. The rule compares the input values to a reference table of names that are unlikely to be genuine. For example, the reference table includes the names of fictional characters.
rule_Phone_Country_Code_Validation
Verifies that the country code in a telephone number is correct for the given country name.
When the country name identifies a United States territory, the rule verifies that the country code is correct and that the three-digit area code is a valid area code for a United States territory. For example, the rule validates 1340 as a country code and area code in the United States Virgin Islands.