Transformations
This section describes new transformation features in version 10.2.
Informatica Transformations
This section describes new features in Informatica transformations in 10.2.
Address Validator Transformation
This section describes the new Address Validator transformation features.
The Address Validator transformation contains additional address functionality for the following countries:
Austria
Effective in version 10.2, you can configure the Address Validator transformation to return a postal address code identifier for a mailbox that has two valid street addresses. For example, a building at an intersection of two streets might have an address on both streets. The building might prefer to receive mail at one of the addresses. The other address remains a valid address, but the postal carrier does not use it to deliver mail.
Austria Post assigns a postal address code to both addresses. Austria Post additionally assigns a postal address code identifier to the address that does not receive mail. The postal address code identifier is identical to the postal address code of the preferred address. You can use the postal address code identifier to look up the preferred address with the Address Validator transformation.
To find the postal address code identifier for an address in Austria, select the Postal Address Code Identifier AT output port. Find the port in the AT Supplementary port group.
To find the address that a postal address identifier represents, select the Postal Address Code Identifier AT input port. Find the port in the Discrete port group.
Czech Republic
Effective in version 10.2, you can configure the Address Validator transformation to add RUIAN ID values to a valid Czech Republic address.
You can find the following RUIAN ID values:
- •RUIANAM_ID. Uniquely identifies the address delivery point.
To find the RUIAN ID value that uniquely identifies the address delivery point, select the RUIAN Delivery Point Identifier output port.
- •RUIANSO_ID. Identifies the address to building level.
To find the RUIAN ID value that identifies the address to building level, select the RUIAN Building Identifier output port.
- •RUIANTEA_ID. Identifies the building entrance.
To find the RUIAN ID value that identifies the entrance to building, select the RUIAN Building Entrance Identifier output port.
Find the ports in the CZ Supplementary port group.
Hong Kong
The Address Validator transformation includes the following features for Hong Kong:
- Multilanguage support for Hong Kong addresses
- Effective in version 10.2, the Address Validator transformation can read and write Hong Kong addresses in Chinese or in English.
- Use the Preferred Language property to select the preferred language for the addresses that the transformation returns. The default language is Chinese. To return Hong Kong addresses in English, update the property to ENGLISH.
- Use the Preferred Script property to select the preferred character set for the address data. The default character set is Hanzi. To return Hong Kong addresses in Latin characters, update the property to a Latin or ASCII option. When you select a Latin script, address validation transliterates the address data into Pinyin.
- Single-line address validation in suggestion list mode
- Effective in version 10.2, you can configure the Address Validator transformation to return valid suggestions for a Hong Kong address that you enter on a single line. To return the suggestions, configure the transformation to run in suggestion list mode.
- Submit the address in the native Chinese language and in the Hanzi script. The Address Validator transformation reads the address in the Hanzi script and returns the address suggestions in the Hanzi script.
- Submit a Hong Kong address in the following format:
[Province] [Locality] [Street] [House Number] [Building 1] [Building 2] [Sub-building]
- When you submit a partial address, the transformation returns one or more address suggestions for the address that you enter. When you enter a complete or almost complete address, the transformation returns a single suggestion for the address that you enter.
- To verify single-line addresses, use the Complete Address port.
Macau
The Address Validator transformation includes the following features for Macau:
- Multilanguage support for Macau addresses
- Effective in version 10.2, the Address Validator transformation can read and write Macau addresses in Chinese or in Portuguese.
- Use the Preferred Language property to select the preferred language for the addresses that the transformation returns. The default language is Chinese. To return Macau addresses in Portuguese, update the property to ALTERNATIVE_2.
- Use the Preferred Script property to select the preferred character set for the address data. The default character set is Hanzi. To return Macau addresses in Latin characters, update the property to a Latin or ASCII option.
Note: When you select a Latin script with the default preferred language option, address validation transliterates the Chinese address data into Cantonese or Mandarin. When you select a Latin script with the ALTERNATIVE_2 preferred language option, address validation returns the address in Portuguese.
- Single-line address verification for native Macau addresses in suggestion list mode
- Effective in version 10.2, you can configure the Address Validator transformation to return valid suggestions for a Macau address that you enter on a single line in suggestion list mode. When you enter a partial address in suggestion list mode, the transformation returns one or more address suggestions for the address that you enter. Submit the address in the Chinese language and in the Hanzi script. The transformation returns address suggestions in the Chinese language and in the Hanzi script. Enter a Macau address in the following format:
[Locality] [Street] [House Number] [Building]
- Use the Preferred Language property to select the preferred language for the addresses. The default preferred language is Chinese. Use the Preferred Script property to select the preferred character set for the address data. The default preferred script is Hanzi. To verify single-line addresses, enter the addresses in the Complete Address port.
Taiwan
Effective in version 10.2, you can configure the Address Validator transformation to return a Taiwan address in the Chinese language or the English language.
Use the Preferred Language property to select the preferred language for the addresses that the transformation returns. The default language is traditional Chinese. To return Taiwan addresses in English, update the property to ENGLISH.
Use the Preferred Script property to select the preferred character set for the address data. The default character set is Hanzi. To return Taiwan addresses in Latin characters, update the property to a Latin or ASCII option.
Note: The Taiwan address structure in the native script lists all address elements in a single line. You can submit the address as a single string in a Formatted Address Line port.
When you format an input address, enter the elements in the address in the following order:
Postal Code, Locality, Dependent Locality, Street, Dependent Street, House or Building Number, Building Name, Sub-Building Name
United States
The Address Validator transformation includes the following features for the United States:
- Support for the Secure Hash Algorithm-compliant versions of CASS data files
- Effective in version 10.2, the Address Validator transformation reads CASS certification data files that comply with the SHA-256 standard.
- The current CASS certification files are numbered USA5C101.MD through USA5C126.MD. To verify United States addresses in certified mode, you must use the current files.
Note: The SHA-256-compliant files are not compatible with older versions of Informatica.
- Support for Door Not Accessible addresses in certified mode
- Effective in version 10.2, you can configure the Address Validator transformation to identify United States addresses that do not provide a door or entry point for a mail carrier. The mail carrier might be unable to deliver a large item to the address.
- The United States Postal Service maintains a list of addresses for which a mailbox is accessible but for which a physical entrance is inaccessible. For example, a residence might locate a mailbox outside a locked gate or on a rural route. The address reference data includes the list of inaccessible addresses that the USPS recognizes. Address validation can return the accessible status of an address when you verify the address in certified mode.
- To identify DNA addresses, select the Delivery Point Validation Door not Accessible port. Find the port in the US Specific port group.
- Support for No Secure Location address in certified mode
- Effective in version 10.2, you can configure the Address Validator transformation to identify United States addresses that do not provide a secure mailbox or reception point for mail. The mail carrier might be unable to deliver a large item to the address.
- The United States Postal Service maintains a list of addresses at which the mailbox is not secure. For example, a retail store is not a secure location if the mail carrier can enter the store but cannot find a mailbox or an employee to receive the mail. The address reference data includes the list of non-secure addresses that the USPS recognizes. Address validation can return the non-secure status of an address when you verify the address in certified mode.
- To identify DNA addresses, select the Delivery Point Validation No Secure Location port. Find the port in the US Specific port group.
- Support for Post Office Box Only Delivery Zones
- Effective in version 10.2, you can configure the Address Validator transformation to identify ZIP Codes that contain post office box addresses and no other addresses. When all of the addresses in a ZIP Code are post office box addresses, the ZIP Code represents a Post Office Box Only Delivery Zone.
- The Address Validator transformation adds the value Y to an address to indicate that it contains a ZIP Code in a Post Office Box Only Delivery Zone. The value enables the postal carrier to sort mail more easily. For example, the mailboxes in a Post Office Box Only Delivery Zone might reside in a single post office building. The postal carrier can deliver all mail to the Post Office Box Only Delivery Zone in a single trip.
- To identify Post Office Box Only Delivery Zones, select the Post Office Box Delivery Zone Indicator port. Find the port in the US Specific port group.
For more information, see the Informatica 10.2 Developer Transformation Guide and the Informatica 10.2 Address Validator Port Reference.
Data Processor Transformation
This section describes new Data Processor transformation features.
JsonStreamer
Use the JsonStreamer object in a Data Processor transformation to process large JSON files. The transformation splits very large JSON files into complete JSON messages. The transformation can then call other Data Processor transformation components, or a Hierarchical to Relational transformation, to complete the processing.
For more information, see the "Streamers" chapter in the Informatica Data Transformation 10.2 User Guide.
RunPCWebService
Use the RunPCWebService action to call a PowerCenter mapplet from within a Data Processor transformation.
For more information, see the "Actions" chapter in the Informatica Data Transformation 10.2 User Guide.
PowerCenter Transformations
Evaluate Expression
Effective in version 10.2, you can evaluate expressions that you configure in the Expression Editor of an Expression transformation. When you test an expression, you can enter sample data and then evaluate the expression.
For more information about evaluating an expression, see the "Working with Transformations" chapter and the "Expression Transformation" chapter in the Informatica PowerCenter 10.2 Transformation Guide.