Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.4.1
  3. Part 2: Version 10.4.0
  4. Part 3: Version 10.2.2
  5. Part 4: Version 10.2.1
  6. Part 5: Version 10.2
  7. Part 6: Version 10.1.1
  8. Part 7: Version 10.1

Address Validator Transformation

Address Validator Transformation

This section describes the new Address Validator transformation features.
The Address Validator transformation contains additional address functionality for the following countries:

Argentina

Effective in version
10.2.1
, you can configure
Informatica
to return valid suggestions for an Argentina address that you enter on a single line.
Enter an Argentina address in the following format:
[Street] [House Number] [Dependent Locality] [Post Code] [Locality]
To verify single-line addresses, enter the addresses in the
Complete Address
port.

Brazil

Effective in version
10.2.1
, you can configure
Informatica
to return valid suggestions for a Brazil address that you enter on a single line.
Enter a Brazil address in the following format:
[Street] [House Number] [Locality] [State Code] [Post Code]
To verify single-line addresses, enter the addresses in the
Complete Address
port.

Colombia

Effective in version
10.2.1
,
Informatica
validates an address in Colombia to house number level.

Hong Kong

Effective in version
10.2.1
,
Informatica
supports rooftop geocoding for Hong Kong addresses.
Informatica
can return rooftop geocoordinates for a Hong Kong address that you submit in the Chinese language or the English language.
Informatica
can consider all three levels of building information when it generates the geocoordinates. It delivers rooftop geocoordinates to the lowest level available in the verified address.
To retrieve rooftop geocoordinates for Hong Kong addresses, install the
HKG5GCRT.MD
database.

India

Effective in version
10.2.1
,
Informatica
validates an address in India to house number level.

Mexico

Effective in version
10.2.1
, you can configure
Informatica
to return valid suggestions for a Mexico address that you enter on a single line.
Enter a Mexico address in the following format:
[Street] [House Number] [Sub-locality] [Post Code] [Locality] [Province]
To verify single-line addresses, enter the addresses in the
Complete Address
port.

South Africa

Effective in version
10.2.1
,
Informatica
improves the parsing and verification of delivery service descriptors in South Africa addresses.
Informatica
improves the parsing and verification of the delivery service descriptors in the following ways:
  • Address Verification recognizes Private Bag, Cluster Box, Post Office Box, and Postnet Suite as different types of delivery service. Address Verification does not standardize one delivery service descriptor to another. For example, Address Verification does not standardize Postnet Suite to Post Office Box.
  • Address Verification parses Postnet Box as a non-standard delivery service descriptor and corrects Postnet Box to the valid descriptor Postnet Suite.
  • Address Verification does not standardize the sub-building descriptor Flat to Fl.

South Korea

Effective in version
10.2.1
,
Informatica
introduces the following features and enhancements for South Korea:
  • The South Korea address reference data includes building information.
    Informatica
    can read, verify, and correct building information in a South Korea address.
  • Informatica
    returns all of the current addresses at a property that an older address represents. The older address might represent a single current address or it might represent multiple addresses, for example if multiple residences occupy the site of the property.
    To return the current addresses, first find the address ID for the older property. When you submit the address ID with the final character A in address code lookup mode,
    Informatica
    returns all current addresses that match the address ID.
    The Address Validator transformation uses the
    Max Result Count
    property to determine the maximum number of addresses to return for the address ID that you enter. The
    Count Overflow
    property indicates whether the database contains additional addresses for the address ID.

Thailand

Effective in version
10.2.1
,
Informatica
introduces the following features and enhancements for Thailand:
Improvements to Thailand Addresses
Informatica
improves the parsing and validation of Thailand addresses in a Latin script.
Additionally,
Informatica
validates an address to house number level.
Native Support for Thailand Addresses
Informatica
can read and write Thailand addresses in native Thai and Latin scripts. Informatica updates the reference data for Thailand and adds reference data in the native Thai script.
Informatica provides separate reference databases for Thailand addresses in each script. To verify addresses in the native Thai script, install the native Thai databases. To verify addresses in a Latin script, install the Latin databases.
If you verify Thailand addresses, do not install both database types. Accept the default option for the
Preferred Script
property.

United Arab Emirates

Effective in version
10.2.1
,
Informatica
verifies street names in United Arab Emirates addresses. To verify street names in United Arab Emirates, install the current reference address databases for the United Arab Emirates.

United Kingdom

Effective in version
10.2.1
,
Informatica
can return a United Kingdom territory name.
Informatica
returns the territory name in the Country_2 element.
Informatica
returns the country name in the Country_1 element. You can configure an output address with both elements, or you can omit the Country_1 element if you post mail within the United Kingdom. The territory name appears above the postcode in a United Kingdom address on an envelope or label.
To return the territory name, install the current United Kingdom reference data.

United States

Effective in version
10.2.1
,
Informatica
can recognize up to three sub-building levels in a United States address.
In compliance with the United States Postal Service requirements,
Informatica
matches the information in a single sub-building element with the reference data. If the Sub-building_1 information does not match,
Informatica
compares the Sub-building_2 information. If the Sub-building_2 information does not match, Address Verification compares the Sub-building_3 information. Address Verification copies the unmatched sub-building information from the input address to the output address.

Austria, Germany, and Switzerland

Effective in version
10.2.1
,
Informatica
supports the uppercase character
in Austria, Germany, and Switzerland addresses.
Informatica
supports the character
in the following ways:
  • If you set the
    Casing
    property to UPPER,
    Informatica
    returns the German character
    ß
    as
    . If you set the
    Casing
    property to LOWER,
    Informatica
    returns the German character
    as
    ß
    .
  • Informatica
    treats
    and
    ß
    as equally valid characters in an address. In reference data matches,
    Informatica
    can identify a perfect match when the same values contain either
    or
    ß
    .
  • Informatica
    treats
    and
    ss
    as equally valid characters in an address. In reference data matches,
    Informatica
    can identify a standardized match when the same values contain either
    or
    ss
    .
  • If you set the
    Preferred Script
    property to ASCII_SIMPLIFIED,
    Informatica
    returns the character
    as
    S
    .
  • If you set the
    Preferred Script
    property to ASCII_EXTENDED,
    Informatica
    returns the character
    as
    SS
    .
For comprehensive information about the features and operations of the address verification software engine version that Informatica embeds in version
10.2.1
, see the
Informatica Address Verification 5.12.0 Developer Guide
.


Updated August 28, 2020