Accelerator Guide

10.4.0
- 10.5.4
- 10.5

Back Next

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."

Rename Saved Search

Table of Contents

Accelerator Guide

Accelerator Guide

U.S./Canada Address Data Cleansing Rules

U.S./Canada Address Data Cleansing Rules