Table of Contents

Search

  1. Preface
  2. Introduction to Accelerators
  3. Core Accelerator
  4. Data Domains Accelerator
  5. Australia/New Zealand Accelerator
  6. BCBS 239/CCAR Accelerator
  7. Brazil Accelerator
  8. Financial Services Accelerator
  9. France Accelerator
  10. Germany Accelerator
  11. India Accelerator
  12. Italy Accelerator
  13. Portugal Accelerator
  14. Spain Accelerator
  15. United Kingdom Accelerator
  16. U.S./Canada Accelerator

Accelerator Guide

Accelerator Guide

Brazil Contact Data Cleansing Rules

Brazil 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 Brazil accelerator:
Name
Description
rule_BRA_Gender_Assignment
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.
rule_BRA_Given_Name_Standard
Generate given names from Brazilian nicknames.
rule_BRA_Personal_CPF_Validation
Validates check digits for Cadastro de Pessoas Físicas (CPF) numbers.
rule_BRA_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_BRA_Personal_PIS_PASEP_Validation
Validates Brazilian social insurance numbers.
rule_BRA_Personal_Voter_Registration_Validation
Validate the check digits in Brazil voter registration numbers.
rule_BRA_Phone_Number_Parse
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.
rule_BRA_Phone_Number_Standardization
Standardizes Brazilian telephone numbers. The rule returns the telephone number in the following formats:
  • Standard - nn nnnn nnnn
  • Dashes - nn-nnnn-nnnn
  • No Spaces - nnnnnnnnnn
rule_BRA_Phone_Validatation
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.
rule_BRA_Prename_Assignment
Generates an honorific according to the gender. You can change the female_prename expression variable from "Sra" to "Sta".
rule_BRA_Salutation_Assignment
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.

Dependencies on Core Contact Data Cleansing Rules

The Brazil accelerator depends on the following contact data cleansing rules from the Core accelerator:
  • rule_Email_Parse_Into_Mailbox_Domain
  • rule_Email_Validation
For more information about these rules, see OOTB Contact Data Cleansing Rules.