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