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

U.S./Canada Composite Rules

U.S./Canada Composite Rules

Use the composite rules in the U.S./Canada accelerator to add a set of rules to a mapping as a single object. A composite rule is a rule that makes use of the logic of other accelerator rules.
Find the composite rules in the following repository location:
[Informatica_DQ_Content]\Rules\Composite_Rules
The following table describes the composite rules in the U.S./Canada accelerator:
Name
Description
rule_CAN_Contact_Data
Parses, standardizes, and validates Canada contact data, such as addresses, telephone numbers, and Social Insurance Numbers (SIN).
rule_USA_Contact_Data
Parses, standardizes, and validates United States contact data, such as addresses, telephone numbers, and Social Security Numbers (SSN).

Composite Rule for Canada Contact Data

The rule
rule_CAN_Contact_Data
reads mapplets from multiple folders in the repository. The rule also includes a nonreusable transformation.
The following table lists the names and the repository locations of the rules and the transformation in
rule_CAN_Contact_Data
:
Rule
Location
Case_Converter
Nonreusable transformation
rule_Assign_DQ_Mailability_Score_Description
Informatica_DQ_Content]\Rules\General_Data_Cleansing
rule_CAN_Address_Validation_Hybrid
[Informatica_DQ_Content]\Rules\Address_Data_Cleansing
rule_CAN_Gender_Assignment
Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_CAN_Multi_Person_Name_Parse
Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_CAN_Phone_Number_Standardization
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_CAN_Phone_Number_Validation
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_CAN_SIN_Standardization
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_CAN_SIN_Validation
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_Company_Name_Standardization
[Informatica_DQ_Content]\Rules\Corporate_Data_Cleansing
rule_Email_Validation
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_Prename_Assignment
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_Salutation_Assignment
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing

Composite Rule for United States Contact Data

The rule
rule_USA_Contact_Data
reads mapplets from multiple folders in the repository. The rule also includes a nonreusable transformation.
The following table lists the names and the repository locations of the rules and the transformation in
rule_USA_Contact_Data
:
Rule
Location
Case_Converter
Nonreusable tranformation
rule_Assign_DQ_Mailability_Score_Description
[Informatica_DQ_Content]\Rules\General_Data_Cleansing
rule_Company_Name_Standardization
[Informatica_DQ_Content]\Rules\Corporate_Data_Cleansing
rule_Email_Validation
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_Prename_Assignment
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_Salutation_Assignment
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_USA_Address_Validation_Hybrid
[Informatica_DQ_Content]\Rules\Address_Data_Cleansing
rule_USA_Gender_Assignment
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_USA_Multi_Person_Name_Parse
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_USA_Phone_Number_Standardization
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_USA_Phone_Number_Validation
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_USA_SSN_Standardization
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
rule_USA_SSN_Validation_post_June2011
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing