Data Quality - Address cleansing

Address cleansing: gives you back a corrected, complete, and standardized form of your original address data.

• Verify that the locality, region, and postal codes agree with one another. If you have just a locality and region, the transform usually can add the postal code and vice versa (depending on the country).
• Standardize the way the address line looks. For example, it can add or strip punctuation or abbreviate or spell-out the primary type (depending on whatyou want).
• Identify any undeliverable addresses, such as vacant lots, condemned buildings, and so on (USA records only).
• Assign diagnostic codes to help you find out why addresses were not assigned or how they had to be corrected. For a listing of these codes for the Global Address Cleanse transform and the USA Regulatory Address Cleanse

Input: The address cleanse transforms accept discrete, multiline, and hybrid address line formats.

• Multiline
• Discrete
• Hybrid
  

Output:

• Parsed address components, which correspond to the input fields, such as locality, region, and postal code.
• Best address components, which are processed data standardized according to the options set in the transform.
• Information about whether any data was changed, added, used, or not used in a corrected component.
  

Transforms:

• Global Address Cleanse and plugins: Must with plugins Australia, Canada, Japan, Multi Country, or USA
• USA Regulatory Address Cleanse: DPV, eLOT, EWS, GeoCensus, LACSLink, RDI, suggestion
  lists (not for certification), and Z4Change. With this transform you can create a USPS Form 3553.
• Global Suggestion Lists : Offers suggestions for possible address matches for your global address data.
• Country ID Identifies the country of destination for the record and outputs an ISO code.
  

Set up the reference files:

• Directories
• Substitution files

Define the standardization options: Standardization changes the way the data is presented after an assignment has been made.