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

U.S./Canada Address Data Cleansing Rules

U.S./Canada Address Data Cleansing Rules

Use address data cleansing rules to parse, standardize, and validate address data.
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 U.S./Canada accelerator:
Name
Description
rule_CAN_Address_Certification_Hybrid
Validates the deliverability of Canadian addresses to the Software Evaluation and Recognition Program (SERP) standards that Canada Post maintains for Canadian addresses. The rule corrects errors in the input addresses where possible and includes a status port that identifies the addresses that meet the SERP standard. Use the rule when you can connect the input address fields to the Hybrid input ports on the Address Validator transformation.
When you certify a set of address records to the SERP standard, you must submit a certification report to Canada Post. The Address Validator transformation includes property fields that you can populate with information for the report. Save or print the report, and include it with the address details that you submit to Canada Post.
rule_CAN_Address_Parse_Hybrid
Parses unstructured Canadian 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_CAN_Address_Parse_Multiline
Parses unstructured Canadian 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_CAN_Address_Validation_Discrete_w_Geocoding
Validates the deliverability of Canadian 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_CAN_Address_Validation_Discrete
Validates the deliverability of Canadian 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_CAN_Address_Validation_Hybrid_w_Geocoding
Validates the deliverability of Canadian 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_CAN_Address_Validation_Hybrid
Validates the deliverability of Canadian 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_CAN_Address_Validation_Multiline_w_Geocoding
Validates the deliverability of Canadian 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_CAN_Address_Validation_Multiline
Validates the deliverability of Canadian 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_CAN_Postcode_Validation
Validates Canadian postal codes. The rule returns "Valid" or "Invalid."
rule_CAN_Province_Validation
Validates Canadian province names. The rule returns "Valid" or "Invalid."
rule_USA_Address_Certification_Hybrid
Validates the deliverability of United States addresses to the Coding Accuracy Support System (CASS) standards that the United States Postal Service maintains for the addresses. The rule corrects errors in the input addresses where possible and includes a status port that identifies the addresses that meet the CASS standard. Use the rule when you can connect the input address fields to the Hybrid input ports on the Address Validator transformation.
When you certify a set of address records to the CASS standard, you must submit a certification report to the USPS. The Address Validator transformation includes property fields that you can populate with information for the report. Save or print the report, and include it with the address details that you submit to the USPS.
rule_USA_Address_Parse_Hybrid
Parses unstructured United States 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_USA_Address_Parse_Multiline
Parses unstructured United States 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_USA_Address_Validation_Discrete_w_Geocoding
Validates the deliverability of United States 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_USA_Address_Validation_Discrete
Validates the deliverability of United States 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_USA_Address_Validation_Hybrid_w_Geocoding
Validates the deliverability of address records from United States 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_USA_Address_Validation_Hybrid
Validates the deliverability of address records from United States 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_USA_Address_Validation_Multiline_w_Geocoding
Validates the deliverability of United States. 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_USA_Address_Validation_Multiline
Validates the deliverability of U.S. 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_USA_County_Validation
Validates United States county names. The rule compares input data against county names in all states. The rule returns "Valid" or "Invalid."
rule_USA_State_Validation
Validates United States state names. The rule returns "Valid" or "Invalid."
rule_USA_ZIPCode_Validation
Validates five-digit United States Zone Improvement Plan (ZIP) Codes. The rule returns "Valid" or "Invalid."