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
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