Informatica Transformations
This section describes changes to the Informatica transformations in version 10.2.1.
Address Validator Transformation
This section describes changes to the Address Validator transformation in version 10.2.1.
The Address Validator transformation contains the following updates to address functionality:
All Countries
Effective in version 10.2.1, the Address Validator transformation uses version 5.12.0 of the Informatica Address Verification software engine. The engine enables the features that Informatica adds to the Address Validator transformation in version 10.2.1.
Previously, the transformation used version 5.11.0 of the Informatica Address Verification software engine.
United Kingdom
Effective from November 2017, Informatica ceases the delivery of reference data files that contain the names and addresses of businesses in the United Kingdom. Informatica ceases to support the verification of the business names and addresses.
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.
Data Transformation
This section describes changes to the Data Processor transformation in version 10.2.1.
Effective in 10.2.1, Data Processor transformation performs strict validation for hierarchical input. When strict validation applies, the hierarchical input file must conform strictly to its schema. This option can be applied when the Data Processor mode is set to Output Mapping, which creates output ports for relational output.
This option does not apply to mappings with JSON input from versions previous to version 10.2.1.
For more information, see the Data Transformation 10.2.1 User Guide.
Sequence Generator Transformation
This section describes changes to the Sequence Generator transformation in version 10.2.1.
Maintain Row Order
Effective in version 10.2.1, the Maintain Row Order property for the Sequence Generator transformation is set to False by default.
Previously, the default value was True.
If you upgrade from an earlier version, the Maintain Row Order property on any Sequence Generator transformation in the repository does not change.
For more information, see the "Sequence Generator Transformation" chapter in the Informatica 10.2.1 Developer Transformation Guide.
Sorter Transformation
This section describes changes to the Sorter transformation in version 10.2.1.
Sorter Caches
Effective in version 10.2.1, the sorter cache for the Sorter transformation uses variable length to store data up to 8 MB in the native environment and on the Blaze engine in the Hadoop environment.
Previously, the sorter cache used variable length to store data up to 64 KB. For data that exceeded 64 KB, the sorter cache stored the data using fixed length.
For more information, see the "Sorter Transformation" chapter in the Informatica 10.2.1 Developer Transformation Guide.
Sorter Performance
Effective in version 10.2.1, the Sorter transformation is optimized to perform faster sort key comparisons for data up to 8 MB.
The sort key comparison rate is not optimized in the following situations:
- •Binary sort order is not selected.
- •The sort key is a timestamp with time zone data type.
- •You perform case-sensitive string comparison and any of the sort key columns is a string data type.
Previously, the Sorter transformation performed faster sort key comparisons for data up to 64 KB. For data that exceeded 64 KB, the sort key comparison rate was not optimized.
For more information, see the "Sorter Transformation" chapter in the Informatica 10.2.1 Developer Transformation Guide.