Informatica Transformations
This section describes changes to Informatica transformations in version 10.2.2.
Address Validator Transformation
This section describes the changes to the Address Validator transformation.
The Address Validator transformation contains the following updates to address functionality:
All Countries
Effective in version 10.2.2, the Address Validator transformation incorporates features from version 5.14.0 of the Informatica Address Verification software engine.
Previously, the transformation used version 5.12.0 of the Informatica Address Verification software engine.
Japan
Effective in version 10.2.2, Informatica improves the parsing and validation of Japan addresses based on customer feedback.
For example, in version 10.2.2, Informatica rejects a Japan address when the postal code is absent from the address or the postal code and the locality information do not match.
Previously, Informatica tried to correct the address.
Spain
Effective in version 10.2.2, Informatica improves the parsing and validation of Spain addresses.
For example, in version 10.2.2, the Address Validator transformation rejects a Spain address when the street information needs multiple corrections to create a match with the reference data.
Previously, the transformation performed multiple corrections to the street data, which might lead to an optimistic assessment of the input address accuracy.
Similarly, in version 10.2.2, if an address matches multiple candidates in the reference data, the Address Validator transformation returns a I3 result for the address in batch mode.
Previously, the transformation might try to correct the input address.
Parcel Centroid and Rooftop Geocodes
Effective October 2018, Informatica no longer supports the reference data files that contain Parcel Centroid and Rooftop geocode data.
For comprehensive information about the updates to the Informatica Address Verification software engine, see the Informatica Address Verification 5.14.0 Release Guide.
Write Transformation
Effective in version 10.2.2, the Create or Replace Target Tables advanced property in a Write transformation for relational, Netezza, and Teradata data objects is renamed to Target Schema Strategy.
When you configure a Write transformation, you can choose from the following target schema strategy options for the target data object:
- •RETAIN - Retain existing target schema. The Data Integration Service retains the existing target schema.
- •CREATE - Create or replace table at run time. The Data Integration Service drops the target table at run time and replaces it with a table based on a target data object that you identify.
- •Assign Parameter. Specify the Target Schema Strategy options as a parameter value.
Previously, you selected the Create or Replace Target Tables advanced property so that the Data Integration Service drops the target table at run time and replaces it with a table based on a target table that you identify. When you do not select the Create or Replace Target Tables advanced property, the Data Integration Service retains the existing schema for the target table.
In existing mappings where the Create or Replace Target Tables property was enabled, after the upgrade to version 10.2.2, by default, the Target Schema Strategy property shows enabled for the CREATE - Create or replace table at run time option. In mappings where the Create or Replace Target Tables option was not selected, after the upgrade, the Target Schema Strategy property is enabled for the RETAIN - Retain existing target schema option. After the upgrade, if the correct target schema strategy option is not selected, you must manually select the required option from the Target Schema Strategy list, and then run the mapping.
For more information about configuring the target schema strategy, see the "Write Transformation" chapter in the Informatica Transformation Guide, or the "Dynamic Mappings" chapter in the Informatica Developer Mapping Guide.