Table of Contents


  1. Preface
  2. Part 1: Version 10.2
  3. Part 2: Version 10.1.1
  4. Part 3: Version 10.1
  5. Part 4: Version 10.0
  6. Part 5: Version 9.6.1
  7. Part 6: Version 9.6.0

Sorter Transformation

Sorter Transformation

This section describes changes to the Sorter transformation in version 10.0.

Cache Size

Effective in version 10.0, the Sorter transformation pages fewer cache files to the disk which improves performance. If the configured cache size is too small for the Sorter transformation, the Data Integration Service processes some of the data in memory and only stores overflow data in cache files.
Previously, if the cache size was too small, the Data Integration Service paged all the cache files to the disk.

Sort Keys and Distinct Rows

Effective in version 10.0, you define the sort keys on the
tab of the Sorter transformation
view. You can also choose to create distinct rows on the
You can parameterize the ports you want to include in the sort key with a sort list parameter. You can include dynamic ports in the Sorter transformation.
Previously, you selected ports for sort keys on the
tab of the transformation
view. You selected to create distinct rows on the
The following image shows the Sort tab:
For more information, see the
Informatica 10.0 Developer Transformation Guide