The Sorted Input option decreases the use of aggregate caches. When you use the Sorted Input option,

Data Integration

assumes all data is sorted by group. As

Data Integration

reads rows for a group, it performs aggregate calculations. When necessary, it stores group information in memory.

The Sorted Input option reduces the amount of data cached during the task run and improves performance. To pass sorted data to the Aggregator transformation, use sorted input with either the Source transformation source filter or a Sorter transformation.

You can increase performance when you sort input in mappings with multiple partitions.