Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.4.0
  3. Part 2: Version 10.2.2
  4. Part 3: Version 10.2.1
  5. Part 4: Version 10.2
  6. Part 5: Version 10.1.1
  7. Part 6: Version 10.1

Sorter Transformation

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
.


Updated September 25, 2020