Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Informatica Data Quality 10.5.1
  • All Products

Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.5.1
  3. Part 2: Versions 10.5 - 10.5.0.1
  4. Part 3: Versions 10.4.1 - 10.4.1.3
  5. Part 4: Versions 10.4 - 10.4.0.2
  6. Part 5: Versions 10.2.2 - 10.2.2 HotFix 1
  7. Part 6: Version 10.2.1
  8. Part 7: Version 10.2 - 10.2 HotFix 2

What's New and Changed (10.5.1)

What's New and Changed (10.5.1)

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
.
0 COMMENTS
We’d like to hear from you!