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

United Kingdom Address Data Cleansing Rules

United Kingdom Address Data Cleansing Rules

Use the address data cleansing rules to parse, standardize, and validate address data.
Find the address data cleansing rules in the following repository location:
[Informatica_DQ_Content]\Rules\Address_Data_Cleansing
The following table describes the address data cleansing rules in the United Kingdom accelerator:
Name
Description
rule_GBR_Address_Parse_Hybrid
Parses unstructured United Kingdom addresses into address elements. The rule does not validate the addresses. Use the rule when you can connect the input address fields to the Hybrid input ports on the Address Validator transformation.
rule_GBR_Address_Parse_Multiline
Parses unstructured United Kingdom addresses into address elements. The rule does not validate the addresses. Use the rule when you can connect the input address fields to the Multiline input ports on the Address Validator transformation.
rule_GBR_Address_Validation_Discrete_w_Geocoding
Validates the deliverability of United Kingdom addresses and adds latitude and longitude coordinates to each output address. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Discrete input ports on the Address Validator transformation.
rule_GBR_Address_Validation_Discrete
Validates the deliverability of United Kingdom addresses. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Discrete input ports on the Address Validator transformation.
rule_GBR_Address_Validation_Hybrid_w_Geocoding
Validates the deliverability of United Kingdom addresses and adds latitude and longitude coordinates to each output address. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Hybrid input ports on the Address Validator transformation.
rule_GBR_Address_Validation_Hybrid
Validates the deliverability of United Kingdom addresses. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Hybrid input ports on the Address Validator transformation.
rule_GBR_Address_Validation_Multiline_w_Geocoding
Validates the deliverability of United Kingdom addresses and adds latitude and longitude coordinates to each output address. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Multiline input ports on the Address Validator transformation.
rule_GBR_Address_Validation_Multiline
Validates the deliverability of United Kingdom addresses. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Multiline input ports on the Address Validator transformation.
rule_GBR_Postcode_Parse
Parses United Kingdom postal codes.
rule_GBR_Postcode_Standardize
Standardizes United Kingdom postal codes. The rule requires that the input follows predefined formats.
The rule standardizes inputs that match the following patterns:
  • A9 9AA
  • A99 9AA
  • AA9 9AA
  • AA99 9AA
  • A9A 9AA
  • AA9A 9AA
  • GIR 0AA
The letter A represents an alphabetic character and the number 9 represents a digit.
rule_GBR_Postcode_Validate
Validates United Kingdom postal codes. The rule matches standardized postal codes with valid United Kingdom postal codes. If the rule does not find a matching postal code, it verifies whether the postal code follows the standard United Kingdom postal code pattern.