Table of Contents

Search

  1. Preface
  2. Content Installation
  3. Configuration Steps for Address Reference Data
  4. Appendix A: Address Validator Transformation Advanced Properties

Address Reference Data Prerequisites

Address Reference Data Prerequisites

Install Informatica Data Quality
or PowerCenter
before you install address reference data to either product.
Before you install address reference data for PowerCenter, stop the PowerCenter Integration Service.
Before you install address reference data for Data Quality, stop the Data Integration Service and the Content Management Service. After you install the data, restart any service that you stopped. If you do not stop and restart the services when you install address reference data, the Address Validator transformation continues to run any older data that it stores in memory.
The Address Validator transformation can read the following types of address reference data:
Address code lookup data
Install address code lookup data to retrieve a partial address or full address from a code value on an input port. The completeness of the address depends on the level of address code support in the country to which the address belongs. To read the address code from an input address, select the country-specific ports in the Discrete port group.
You can select ports for the following countries:
  • Austria. Returns an address to building level.
  • Germany. Returns an address to locality, municipality, or street level.
  • Japan. Returns an address to the unique mailbox level.
  • South Africa. Returns an address to street level.
  • South Korea. Returns an address to the unique mailbox level.
  • Serbia. Returns an address to street level.
  • United Kingdom. Returns an address to the unique mailbox level.
The Address Validator transformation reads address code lookup data when you configure the transformation to run in address code lookup mode.
Batch and interactive data
Install batch and interactive data to perform address validation on a set of address records. Use batch and interactive data to verify that the input addresses are fully deliverable and complete based on the current postal data from the national mail carrier.
When you configure the transformation to run in batch mode, the Address Validator transformation returns a single address for each input address. When you configure the transformation to run in interactive mode, the Address Validator transformation returns one or more addresses for each input address.
CAMEO data
Install CAMEO data to add customer segmentation data to residential address records. Customer segmentation data indicates the likely income level and lifestyle preferences of the residents at each address.
The Address Validator transformation reads CAMEO data when you configure the transformation to run in batch mode or certified mode.
Certified data
Install certified data to verify that address records meet the certification standards that a mail carrier defines. An address meets a certification standard if contains data elements that can identify a unique mailbox, such as delivery point data elements. When an address meets a certification standard, the mail carrier charges a reduced delivery rate.
The following countries define certification standards:
  • Australia. Certifies mail according to the Address Matching Approval System (AMAS) standard.
  • Canada. Certifies mail according to the Software Evaluation And Recognition Program (SERP) standard.
  • France. Certifies mail according to the National Address Management Service (SNA) standard.
  • New Zealand. Certifies mail according to the SendRight standard.
  • United States. Certifies mail according to the Coding Accuracy Support System (CASS) standard.
The Address Validator transformation reads certified data when you configure the transformation to run in certified mode.
Geocode data
Install geocode data to add geocodes to address records. Geocodes are latitude and longitude coordinates.
The Address Validator transformation reads geocode data when you configure the transformation to run in batch mode or certified mode.
Suggestion list data
Install suggestion list data to find alternative valid versions of a partial address record. Use suggestion list data when you configure an address validation mapping to process address records one by one in real time. The Address Validator transformation uses the data elements in the partial address to perform a duplicate check on the suggestion list data. The transformation returns any valid address that includes the information in the partial address.
The Address Validator transformation reads suggestion list data when you configure the transformation to run in suggestion list mode.
Supplementary data
Install supplementary data to add data to an address record that can assist the mail carrier in mail delivery. Use the supplementary data to add detail about the geographical or postal area that contains the address. In some countries, supplementary data can provide a unique identifier for a mailbox within the postal system.
The Address Validator transformation reads supplementary data when you configure the transformation to run in batch mode or certified mode.
The transformation does not read address reference data in country recognition mode or in parse mode.


Updated August 04, 2020