Accelerator Guide

10.5
- 10.5.4
- 10.4.0

Back Next

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

Name	Description
rule_FRA_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 "Jean Leclerc" a gender of "M" for male.
rule_FRA_Given_Name_Standard	Generates given names from French nicknames.
rule_FRA_INSEE_Parse	Parses the French Institut National de la Statistique et des Études Économiques (INSEE) number from a string.
rule_FRA_INSEE_Standardization	Standardizes the French INSEE number to a string of 13 digits or to 13 digits followed by a space and the two-digit control key.
rule_FRA_INSEE_Validation	Validates the INSEE number based on the gender, date, and Code Officiel Géographique (COG) values.
rule_FRA_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 "Jean et Marianne Leclerc" and create output ports for "Jean Leclerc" and "Marianne Leclerc."
rule_FRA_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_FRA_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_FRA_Phone_Number_Parse	Parses a French 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_FRA_Phone_Number_Standardize	Standardizes French 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_FRA_Phone_Number_Validation	Validates the area code and length of French 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_FRA_Prename_Assignment	Generates an honorific according to the gender.
rule_FRA_Salutation_Assignment	Generates formal and casual greetings from prenames and name tokens. For example, when input data contains "M. Jean Leclerc," the rule generates the formal greeting "Monsieur Leclerc," and the casual greeting "Cher Jean,". You can change the prefix and punctuation by editing the variables in the dq_Generate_Salutation Expression transformation.