Data Quality Integration for PowerCenter Guide

10.5.7
- 10.5.6
- 10.5.4
- 10.5
- 10.4.1
- 10.4.0

Back Next

Address Reference Data Requirements

A mapping that performs address validation reads address reference data. You purchase and download address reference data from Informatica. Install the data files to the PowerCenter Integration Service machine.

The following table describes the types of address reference data that you can install:

Type of Reference Data	When To Use
Address Code Lookup	Use to retrieve a partial address or a 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. You can use address code lookup data with address records from 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.
Batch	Use for general address validation operations.
CAMEO	Use to add consumer demographic data to the address records.
Certified	Use to verify that address records meet the certification standards that a mail carrier defines. 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.
Suggestion list	Use to find alternative valid versions of an incomplete address record. Use suggestion list data when you configure an address validation mapping to process single address records in real time.
Geocode	Use to add latitude coordinates and longitude coordinates to the address records.
Supplementary	Use to enrich address records with additional geographic or demographic data.

The PowerCenter Integration Service reads the path to the address reference data from the

AD50.cfg

configuration file.

The PowerCenter installer writes the

AD50.cfg

file to the following path:

[PowerCenter_Installation]/server/bin

When you install address reference data, verify that the following properties are set in

AD50.cfg

Reference Data Location: Enter the path to the address reference data in the
ReferenceDataLocation
property.
License Key Data: Enter license data in the
LicenseKey
property. If you have more than one license, enter each license in a comma-separated string.
Preload Values: Enter at least one country abbreviation as a preload value for each type of reference data that a mapping reads. Enter ALL to apply a preload setting for all countries.
The Integration Service can use a different method to load data for each country. For example, you can specify full preload for United States batch/interactive data and partial preload for United Kingdom batch/interactive data. The Integration Service can also use a different preload method for each type of data. For example, you can specify full preload for United States batch/interactive data and partial preload for United States geocoding data.

Full preload settings supersede partial preload settings, and partial preload settings supersede settings that indicate no data preload. For example, if you enter ALL for no data preload and enter USA for full preload, the Integration Service loads all United States data into memory and does not load data for any other country. If you do not have a preload requirement, enter ALL for no data preload for any type of reference data that you plan to use.

You do not specify a preload value for Supplementary data.