Informatica Data Quality
- Informatica Data Quality 10.4.0
- All Products
Assigns gender according to first name. 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 "Joao Coelho" a gender of "M" for male.
Generate given names from Brazilian nicknames.
Validates check digits for Cadastro de Pessoas Físicas (CPF) numbers.
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.
Validates Brazilian social insurance numbers.
Validate the check digits in Brazil voter registration numbers.
Parses a Brazilian telephone number from a string. The rule parses the first telephone number in the data, reading from left to right. The rule returns a telephone number and also returns a string that contains the input text with the telephone number removed.
Standardizes Brazilian telephone numbers. The rule returns the telephone number in the following formats:
Validates the area code and length of Brazilian telephone numbers. The rule returns codes that indicate if the area code and length of a telephone number are valid.
Generates an honorific according to the gender. You can change the female_prename expression variable from "Sra" to "Sta".
Generates formal and casual greetings from prenames and name tokens. For example, when input data contains "Sr. Joao Coelho," the rule generates the formal greeting "Prezado Sr. Coelho," and the casual greeting "Prezado Joao,". You can change the prefix and punctuation by editing the variables in the dq_Generate_Salutation Expression transformation.
Updated January 30, 2023