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.

Effective in version 10.0, you define the sort keys on the

Sort

tab of the Sorter transformation

Properties

view. You can also choose to create distinct rows on the

Sort

tab.

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

Ports

tab of the transformation

Properties

view. You selected to create distinct rows on the

Advanced

tab.

The following image shows the Sort tab:

For more information, see the

Informatica 10.0 Developer Transformation Guide

.