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

Spain Contact Data Cleansing Rules

Spain 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 Spain accelerator:
Name
Description
rule_ESP_CIF_Parse
Parses the Spanish Certificado de Identificación Fiscal (CIF).
rule_ESP_CIF_Standardization
Standardizes the Spanish Certificado de Identificación Fiscal (CIF).
rule_ESP_CIF_Validation
Validates the Spanish Certificado de Identificación Fiscal (CIF).
rule_ESP_DNI_Parse
Parses the Spanish Documento Nacional de Identidad (DNI).
rule_ESP_DNI_Standardization
Standardizes the Spanish Documento Nacional de Identidad (DNI).
rule_ESP_DNI_Validation
Validates the Spanish Documento Nacional de Identidad (DNI).
rule_ESP_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 "Juan Garcia" a gender of "M" for male.
rule_ESP_Given_Name_Standard
Generates given names from Spanish nicknames.
rule_ESP_NIE_Parse
Parses the Spanish Número de Identidad de Extranjero (NIE).
rule_ESP_NIE_Standardization
Standardizes the Spanish Número de Identidad de Extranjero (NIE).
rule_ESP_NIE_Validation
Validates the Spanish Número de Identidad de Extranjero (NIE).
rule_ESP_NIF_Parse
Parses the Spanish Número de Identificación Fiscal (NIF) from a string.
rule_ESP_NIF_Standardization
Standardizes the Spanish Número de Identificación Fiscal (NIF).
rule_ESP_NIF_Validation
Validates the Spanish Número de Identificación Fiscal (NIF).
rule_ESP_Personal_Name_Parse
Parses Spanish person names.
rule_ESP_Phone_Number_Parse
Parses a Spanish 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_ESP_Phone_Number_Standardization
Standardizes Spanish 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_ESP_Phone_Number_Validation
Validates the area code and length of Spanish 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_ESP_Phone_Parse_Standardize_Validate
Parses Spanish telephone numbers and standardizes format. Validates the area code and length of Spanish telephone numbers.
rule_ESP_Prename_Assignment
Generates an honorific according to the gender.
rule_ESP_Salutation_Assignment
Generates formal and casual greetings from prenames and name tokens. For example, when input data contains " Sr. Juan Garcia," the rule generates the formal greeting " Estimado Sr. Garcia," and the casual greeting "Querido Juan,". 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 Spain accelerator depends on the following contact data cleansing rules from the Core accelerator:
  • rule_Email_Validation
For more information about these rules, see OOTB Contact Data Cleansing Rules.