Accelerator Guide

10.4.0
- 10.5.4
- 10.5

Back Next

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

Name	Description
rule_PRT_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 "Artur Cruz" a gender of "M" for male.
rule_PRT_Given_Name_Standard	Generate given names from Portuguese nicknames.
rule_PRT_NIF_Parse	Parses Número de Identificação Fiscal (NIF) numbers from strings. The rule returns the ID numbers and also returns a string that contains the input text with the ID numbers removed.
rule_PRT_NIF_Standardization	Standardizes Número de Identificação Fiscal (NIF) numbers into a nine-digit string. The rule removes alphabetic characters, symbols, and spaces.
rule_PRT_NIF_Validate	Validates Número de Identificação Fiscal (NIF) numbers based on the check digit in each number. The rule requires that the input is a nine-digit numeric string with no spaces.
rule_PRT_Personal_Name_Parse_Validate	Parses person name values into separate ports. The rule creates ports for values such as title, first name, middle name, and surname. The rule also indicates if the name might be a company name and validates the spelling of the name. 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.
rule_PRT_Phone_Number_Parse	Parses a Portuguese 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_PRT_Phone_Number_Standardization	Standardizes Portuguese telephone numbers to international and local dialing formats.
rule_PRT_Phone_Number_Validation	Validates the area code and length of Portuguese 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_PRT_Prename_Assignment	Generates an honorific according to the gender. You can change the female_prename expression variable from "Sra" to "Sta".
rule_PRT_Salutation_Assignment	Generates formal and casual greetings from prenames and name tokens. For example, when input data contains "Sr. Artur Cruz," the rule generates the formal greeting "Prezado Sr. Cruz," and the casual greeting "Prezado Artur,". You can change the prefix and punctuation by editing the variables in the dq_Generate_Salutation Expression transformation.