Informatica Data Quality
- Informatica Data Quality 10.4.0
- All Products
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
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.
|