Accelerator Guide

Back Next

Italy 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 Italy accelerator:

Name	Description
rule_ITA_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 "Alessandro Scarlatti" a gender of "M" for male.
rule_ITA_Given_Name_Standardization	Returns a standard name for a common nickname.
rule_ITA_Lastname_Validation	Validates that a name is an Italian surname.
rule_ITA_Phone_Number_Parse	Parses an Italian telephone number from a string. The rule parses the first telephone number in the data, reading from right to left. The rule returns a telephone number and also returns a string that contains the input text with the telephone number removed.
rule_ITA_Phone_Number_Standardization	Standardizes Italian 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_ITA_Phone_Number_Validation	Validates the area code and length of Italian 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_ITA_Prename_Assignment	Generates an honorific according to the gender.
rule_ITA_Salutation_Assignment	Generates formal and casual greetings from prenames and name tokens. You can change the prefix and punctuation by editing the variables in the dq_Generate_Salutation Expression transformation.