Data Quality Integration for PowerCenter Guide

Data Quality Integration for PowerCenter Guide

Address Reference Data Requirements

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.
You can optionally edit other properties in
AD50.cfg
.

0 COMMENTS

We’d like to hear from you!