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

Italy General Data Cleansing Rules

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.