Some processing rules for the Blaze engine differ from the processing rules for the Data Integration Service.
Mapping validation fails in the following situations:
The target is configured to maintain row order and the Sorter transformation is not connected directly to a flat file target.
The Data Integration Service enables parallel sorting with the following restrictions:
The mapping does not include another transformation between the Sorter transformation and the target.
The data type of the sort keys does not change between the Sorter transformation and the target.
Each sort key in the Sorter transformation must be linked to a column in the target.
The Blaze engine can perform global sorts in the following situations:
The Sorter transformation is connected directly to flat file targets.
The target is configured to maintain row order.
The sort key is not a binary data type.
If any of the conditions are not true, the Blaze engine performs a local sort.
Data Cache Optimization
If a Sorter transformation is inserted before an Aggregator or Rank transformation to optimize the Aggregator or Rank data cache, the size of the sorter cache is the same size as the data cache for the Aggregator or Rank transformation. To configure the sorter cache, you must configure the size of the data cache for the Aggregator or Rank transformation.