Installation and Getting Started Guide (On-Premises)

Installation and Getting Started Guide (On-Premises)

Reference Databases and Packages

Reference Databases and Packages

Informatica reference databases are proprietary-format database files that contain reference addresses from countries and territories that Informatica supports for address verification. The reference databases are read-only and platform-independent.
The database file names have the following format:
XXXYZZZZ.MD
You can interpret the file names in the following way:
  • XXX
    denotes the ISO 3166-1 alpha 3 code for the country or territory to which the reference data applies. For example,
    USA
    for the United States.
  • Y
    denotes the primary product version. For example,
    5
    .
  • ZZZZ
    denotes the reference database type. For example,
    BI
    for Batch and Interactive.
You download the files in compressed (zip) format. The zip file names follow a similar naming convention to the database file names. The zip file names also include the day, month, and year on which Informatica created the file.
Address Verification provides the following types of reference database:
BI
Batch and interactive data.
FC
Fast completion data.
Cx
Certified data. The x character represents a number. For example,
DB5_CAN5C1_01_150201.zip
contains a SERP-certified reference address database for Canada.
AC
Address code lookup data.
GC
Standard geocoding data.
GCAP
Arrival point geocoding data.
CA
CAMEO data.
Ex
Supplementary data. The x character represents a number. For example,
DB5_FRA5E1_01_150201.zip
contains the supplementary reference address database for France address enrichments.
You might download multiple reference address databases for a country.
Most countries use a single version of each database file. However, a country might have multiple version of a file. An ID number such as
01
,
02
, or
03
, in the zip package name identifies the version of the database file.
For example, the reference data zip files that you can download for Australia can include the two-digit codes _01 and _02 in the file names. Select the _02 version of the file to download reference data that includes sub-building data. Select the _01 version of the file to download reference data without sub-building data.

Unlock Codes

You need valid unlock codes for the database that you download.
The following table describes the unlock code types that the databases require:
Unlock Code Type
Description
VALIDATION
Unlock code for batch and interactive and fast completion databases.
GEO_STANDARD
Unlock code for standard geocoding databases.
GEO_ARRIVAL_POINT
Unlock code for arrival point geocoding databases.
CAMEO
Unlock code for CAMEO databases.
ADDRESS_CODE_LOOKUP
Unlock code for address code lookup databases.
SINGLE_LINE_VALIDATION
Unlock code for single line address validation feature.
SUPPLEMENTARY
Unlock code for supplementary databases that contain information about country-specific enrichments.

0 COMMENTS

We’d like to hear from you!