Table of Contents

Search

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

Content Guide

Content Guide

Address Reference Data Properties

Address Reference Data Properties

The
Data
Integration Service reads address reference data properties when you run an address validation mapping
or session
.
If you run an address validation mapping in Data Quality, the Data Integration Service reads the address reference data properties that you set on the Content Management Service. Use the Administrator tool to configure the Content Management Service properties.
If you run an address validation session in PowerCenter, the Integration Service reads the address reference data properties from the
AD50.cfg
file. Locate the
AD50.cfg
file and configure the properties.
You must enter a license key, the reference data location, and at least one data preload value before you run an address validation mapping or session. Optionally, enter values to the other properties.
The
AD50.cfg
file and the Content Management Service use the same names for the address reference data properties. However, the property names in
AD50.cfg
do not contain spaces. For example, you can set the
Max Address Object Count
property on the Content Management Service. You set the
MaxAddressObjectCount
property in
AD50.cfg
.
The following table describes the address reference data properties:
Property
Description
License
License key to activate validation reference data. You might have more than one key, for example, if you use batch reference data and geocoding reference data. Enter keys as a comma-delimited list. The property is empty by default.
Reference Data Location
Location of the address reference data files. Enter the full path to the files. Install all address reference data files to a single location. The property is empty by default.
Full Pre-Load Countries
List of countries for which all batch, CAMEO, certified, interactive, or supplementary reference data is loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Enter ALL to load all data sets. The property is empty by default.
Load the full reference database to increase performance. Some countries, such as the United States, have large databases that require significant amounts of memory.
Partial Pre-Load Countries
List of countries for which batch, CAMEO, certified, interactive, or supplementary reference metadata and indexing structures are loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Enter ALL to partially load all data sets. The property is empty by default.
Partial preloading increases performance when not enough memory is available to load the complete databases into memory.
No Pre-Load Countries
List of countries for which no batch, CAMEO, certified, interactive, or supplementary reference data is loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Default is ALL.
Full Pre-Load Geocoding Countries
List of countries for which all geocoding reference data is loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Enter ALL to load all data sets. The property is empty by default.
Load all reference data for a country to increase performance when processing addresses from that country. Some countries, such as the United States, have large data sets that require significant amounts of memory.
Partial Pre-Load Geocoding Countries
List of countries for which geocoding reference metadata and indexing structures are loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Enter ALL to partially load all data sets. The property is empty by default.
Partial preloading increases performance when not enough memory is available to load the complete databases into memory.
No Pre-Load Geocoding Countries
List of countries for which no geocoding reference data is loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Default is ALL.
Full Pre-Load Suggestion List Countries
List of countries for which all suggestion list reference data is loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Enter ALL to load all data sets. The property is empty by default.
Load the full reference database to increase performance. Some countries, such as the United States, have large databases that require significant amounts of memory.
Partial Pre-Load Suggestion List Countries
List of countries for which the suggestion list reference metadata and indexing structures are loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Enter ALL to partially load all data sets. The property is empty by default.
Partial preloading increases performance when not enough memory is available to load the complete databases into memory.
No Pre-Load Suggestion List Countries
List of countries for which no suggestion list reference data is loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Default is ALL.
Full Pre-Load Address Code Countries
List of countries for which all address code lookup reference data is loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Enter ALL to load all data sets. The property is empty by default.
Load the full reference database to increase performance. Some countries, such as the United States, have large databases that require significant amounts of memory.
Partial Pre-Load Address Code Countries
List of countries for which the address code lookup reference metadata and indexing structures are loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Enter ALL to partially load all data sets. The property is empty by default.
Partial preloading increases performance when not enough memory is available to load the complete databases into memory.
No Pre-Load Address Code Countries
List of countries for which no address code lookup reference data is loaded into memory before address validation begins. Enter the three-character ISO country codes in a comma-separated list. For example, enter DEU,FRA,USA. Default is ALL.
Preloading Method
Determines how the Data Integration Service preloads address reference data into memory. The MAP method and the LOAD method both allocate a block of memory and then read reference data into this block. However, the MAP method can share reference data between multiple processes. Default is MAP.
Max Result Count
Maximum number of addresses that address validation can return in suggestion list mode. Set a maximum number in the range 1 through 100. Default is 20.
Memory Usage
Number of megabytes of memory that the address validation library files can allocate. Default is 4096.
Max Address Object Count
Maximum number of address validation instances to run at the same time. Default is 3. Set a value that is greater than or equal to the Maximum Parallelism value on the Data Integration Service.
Max Thread Count
Maximum number of threads that address validation can use. Set to the total number of cores or threads available on a machine. Default is 2.
Cache Size
Size of cache for databases that are not preloaded. Caching reserves memory to increase lookup performance in reference data that has not been preloaded.
Set the cache size to LARGE unless all the reference data is preloaded or you need to reduce the amount of memory usage.
Enter one of the following options for the cache size in uppercase letters:
  • NONE. No cache. Enter NONE if all reference databases are preloaded.
  • SMALL. Reduced cache size.
  • LARGE. Standard cache size.
Default is LARGE.
SendRight Report Location
Location to which an address validation mapping writes a SendRight report and any log file that relates to the report. You generate a SendRight report to verify that a set of New Zealand address records meets the certification standards of New Zealand Post. Enter a local path on the machine that hosts the Data Integration Service that runs the mapping.
By default, address validation writes the report file to the
bin
directory of the Informatica installation. If you enter a relative path, the Content Management Service appends the path to the
bin
directory.

0 COMMENTS

We’d like to hear from you!