Informatica Data Quality
- Informatica Data Quality 10.5.4
- All Products
[Informatica_DQ_Content]\Rules\Contact_Data_Cleansing
Name
| Description
|
---|---|
rule_GBR_Driver_Number_Parse
| Parses strings that match the format of United Kingdom driver's license numbers.
|
rule_GBR_Driver_Number_Validation
| Validates United Kingdom driver's license numbers based on the requirements of the United Kingdom Government Data Standards Catalog.
|
rule_GBR_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 "John Smith" a gender of "M" for male.
|
rule_GBR_Given_Name_Standard
| Generate given names from United Kingdom nicknames.
|
rule_GBR_Multi_Person_Name_Parse
| Parses person name values into separate ports. The rule creates ports for values such as title, first name, middle name, and surname.
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.
When the name data identifies more than one person, the rule creates an output port for each full name. For example, the rule can read the name "John and Jane Smith" and create output ports for "John Smith" and "Jane Smith."
|
rule_GBR_NHS_Number_Parse
| Parses National Health Service (NHS) numbers from a string. The rule returns the NHS number and also returns a string that contains the input text with the NHS number removed.
|
rule_GBR_NHS_Number_Standardize
| Standardizes National Health Service (NHS) numbers into the standard format (999 999 9999). The rule requires that the input is a 10-digit string.
|
rule_GBR_NHS_Number_Validate
| Validates National Health Service (NHS) numbers based on the check digit in each number. The rule requires that the input is a 10-digit string.
|
rule_GBR_NINO_Conformity_Check
| Validates the standard pattern for a United Kingdom National Insurance Number (NINO). The rule does not verify that a NINO is accurate or active.
|
rule_GBR_NINO_Parse
| Parses United Kingdom National Insurance Numbers (NINO) from strings. The rule returns the NINO and also returns a string that contains the input text with the NINO removed.
|
rule_GBR_NINO_Standardization
| Standardizes United Kingdom National Insurance Numbers (NINO) into the two most typical formats. The rule returns the following formats, where C represents alphabetic characters and N represents numerals:
The rule formats all alphabetic characters as uppercase. The rule requires that the input conforms to the pattern of a NINO.
|
rule_GBR_NINO_Validation
| Validates a United Kingdom National Insurance Number (NINO). The rule does not verify that a NINO is active.
|
rule_GBR_Passport_Number_MR_Parse
| Parses United Kingdom passport numbers in extended format. The extended format is the machine readable format for passport numbers.
|
rule_GBR_Passport_Number_Parse
| Parses United Kingdom passport numbers that use the format specified by the Government Data Standards Catalogue. The rule parses all nine-digit strings.
|
rule_GBR_Passport_Number_Validation
| Validates United Kingdom passport numbers that use the format specified by the Government Data Standards Catalogue.
|
rule_GBR_Personal_Name_Parsing_FML
| Parses the values in a person name into separate ports.
The rule creates the ports in the following sequence:
The rule output also 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_GBR_Personal_Name_Parsing_LFM
| Parses the values in a person name into separate ports.
The rule creates the ports in the following sequence:
The rule output also 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_GBR_Phone_Number_Parse
| Parses a United Kingdom telephone number from a string. The rule parses the first telephone number in the data, reading from right to left.
The rule recognizes telephone numbers that use leading zeros, the "+44" international dialing code, and extensions that begin with the hash symbol. The rule processes the following punctuation symbols: the plus sign, parentheses, and the hash symbol. Before you run the rule, remove all other punctuation, including double spaces.
The rule returns a telephone number and also returns a string that contains the input text with the telephone number removed.
|
rule_GBR_Phone_Number_Standardization
| Standardizes United Kingdom telephone numbers to international and local dialing formats. The rule recognizes telephone numbers that use leading zeros, the "+44" international dialing code, and extensions that begin with the hash symbol.
|
rule_GBR_Phone_Number_Validation
| Validates the area code and length of United Kingdom 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_Prename_Assignment
| Generates an honorific according to the gender. You can change the female_prename expression variable from Ms. to Mrs.
|
rule_Salutation_Assignment
| Generates formal and casual greetings from prenames and name tokens. For example, when input data contains "Mr. John Smith," the rule generates the formal greeting "Dear Mr. Smith," and the casual greeting "Dear John,". You can change the prefix and punctuation by editing the variables in the dq_Generate_Salutation Expression transformation.
|