Accelerator Guide

10.2.2
- 10.5.4
- 10.5
- 10.4.0
- 10.2.1

Back Next

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

Rename Saved Search

Table of Contents

Accelerator Guide

Accelerator Guide

U.S./Canada Composite Rules

U.S./Canada Composite Rules

Composite Rule for Canada Contact Data

Composite Rule for United States Contact Data