English
Shared Content for Data Engineering All Products

Table of Contents

Search

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

Release Guide

Release Guide

Back Next

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 September 25, 2020

Download Guide
Send Feedback
Explore Informatica Network
Communities
Knowledge Base
Success Portal