To improve mapping performance, the Data Integration Service enables parallel sorting by default in a mapping that has a Sorter transformation and a flat file target.
The Data Integration Service enables parallel sorting for mappings in a Hadoop environment based on the following rules and guidelines:
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.