Installation and Getting Started Guide (On-Premises)

Installation and Getting Started Guide (On-Premises)

Reference Address Databases and Packages

Reference Address Databases and Packages

Informatica Address Verification reference address databases are proprietary-format,
.MD
, databases that contain reference addresses from countries and territories that Address Verification supports for validation.
The reference address databases are read-only and platform-independent. You can use the same database on all platforms that support Address Verification.
You can interpret the reference address database filename,
XXXYZZZZ.MD
, in the following way:
  • XXX
    denotes the ISO 3166-1 alpha 3 code for the country or territory. For example,
    USA
    for the United States.
  • Y
    denotes the Address Verification main version. For example,
    5
    .
  • ZZZZ
    denotes the reference database type. For example, BI for Batch and Interactive or GCAP for High Precision Arrival Point Geocoding.
From Informatica Database Download Manager, you can download .zip packages of country- or territory-specific reference address databases.
The .zip file names follow the
DB5_XXXYZZZZ_NN_YYMMDD.zip
format.
XXX
in the file name denotes the ISO 3166-1 alpha 3 code for the country or territory.
ZZZZ
denotes the reference address database type such as BI or GCAP.
NN
denotes a unique, two-digit product ID.
YYMMDD
denotes the database release date.
For example, you can interpret the file name
DB5_USA5BI_01_150201.zip
in the following way:

    Informatica Address Verification Version 5 (
    DB5
    ) Batch and Interactive (
    BI
    ) database 1 for the United States (
    USA
    ) that Informatica released on February 01, 2015 (
    150201
    ).

Most countries have only one version,
01
, of a database type. However, some countries have multiple version of a database type. The two-digit package ID, such as
01
,
02
, and
03
, in the .zip package name uniquely identifies different versions of a database type.
For example, Australia has two versions each of the BI and FC databases.
DB5_AUS5BI_01_150201.zip
and
DB5_AUS5FC_01_150201.zip
contain the subbuilding information.
DB5_AUS5BI_02_150201.zip
and
DB5_AUS5FC_02_150201.zip
do not contain the subbuilding information.
Address Verification supports the following types of reference address databases:
BI
Batch and interactive
FC
Fast completion
Cx
Certified. x is a numeric. For example,
DB5_CAN5C1_01_150201.zip
contains the SERP-certified reference address database for Canada.
AC
Address code lookup
GC
Standard geocoding
GCAP
Arrival point geocoding
GCPC
Parcel centroid geocoding
GCRT
Rooftop geocoding
CA
CAMEO
Ex
Supplementary. x is a numeric. For example,
DB5_FRA5E1_01_150201.zip
contains the supplementary reference address database for France address enrichments such as INSEE code.
You can find multiple reference address databases for most countries and territories. For example,
DEU5BI.MD
,
DEU5FC.MD
, and
DEU5GC.MD
are some of the reference address databases for Germany addresses.
You need valid unlock codes to unlock these databases. The following table describes the unlock code types that Address Verification supports:
Unlock Code Type
Description
VALIDATION
Unlock code for batch and interactive (BI) and Fast Completion (FC) databases.
GEO_STANDARD
Unlock code for standard geocoding databases.
GEO_ARRIVAL_POINT
Unlock code for the arrival point geocoding databases.
GEO_PARCEL_CENTROID
Unlock code for the parcel centroid geocoding databases.
GEO_ROOFTOP
Unlock code for the rooftop geocoding databases.
CAMEO
Unlock code for the CAMEO databases.
ADDRESS_CODE_LOOKUP
Unlock code for the address code lookup databases.
SINGLE_LINE_VALIDATION
Unlock code for the single line address validation feature.
SUPPLEMENTARY
Unlock code for the supplementary databases that contain information about country-specific enrichments.

0 COMMENTS

We’d like to hear from you!