Informatica Transformations
This section describes new Informatica transformation features in version 10.2.1.
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.
Note: 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.
Note: 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.