Accelerator Guide

10.5.4
- 10.5
- 10.4.0

Back Next

Italy General Data Cleansing Rules

Use the general data cleansing rules to perform general validation and standardization tasks on data and to describe the information in address status fields.

Find the general data cleansing rules in the following repository location:

[Informatica_DQ_Content]\Rules\General_Data_Cleansing

The following table describes the general data cleansing rules in the Italy accelerator:

Name	Description
rule_Assign_DQ_GeocodingStatus_Description	Assigns a description to the Geocoding Status output from the Address Validator transformation. The description corresponds to the output from Data Quality transformations in releases prior to Data Quality 9.0.
rule_Assign_DQ_Mailability_Score_Description	Assigns a description to the Mailability Score output from the Address Validator transformation. The description corresponds to the output from Data Quality transformations in releases prior to Data Quality 9.0.
rule_Assign_DQ_Match_Code_Description	Assigns a description to the Match Code output from the Address Validator transformation. The description corresponds to the output from Data Quality transformations in releases prior to Data Quality 9.0.
rule_Date_Validation	Validates date strings that appear in a single format in a data column. To configure the date format that the rule uses for validation, open the dq_ValidateDate Expression transformation in the rule and update the In_Date_Format expression variable. The default format is "MM/DD/YYYY." The rule returns "Valid" or "Invalid."
rule_ITA_Registration_Number_Plate_Validation	Validates an Italian vehicle registration number.
rule_Remove_Extra_Spaces	Replaces all consecutive spaces with a single space and trims leading and trailing spaces.
rule_Remove_Hyphen	Removes hyphens.
rule_Remove_Non_Numbers	Removes all characters that are not numeric.
rule_Remove_Period_Parentheses	Removes the following characters: - Left and right parentheses - Periods
rule_Remove_Punctuation	Removes punctuation symbols.
rule_Remove_Punctuation_and_Space	Removes all punctuation and all space characters.
rule_Remove_Space	Removes all character spaces.
rule_Replace_Limited_Punct_with_Space	Replaces the following punctuation characters with a single space: dash, back slash, period, exclamation mark, and underscore. The rule also replaces two, three, and four consecutive spaces with a single space.
rule_Replace_Punctuation_with_Space	Replaces all punctuation with spaces.
rule_UpperCase	Returns all alphabetic characters in upper case.

Rename Saved Search

Table of Contents

Accelerator Guide

Accelerator Guide

Italy General Data Cleansing Rules

Italy General Data Cleansing Rules