Mapping Architect for Visio Guide

Back Next

Sorter Transformation

Use the Sorter transformations to sort data. You can sort data in ascending or descending order according to a specified sort key.

The following table describes the required properties for the Sorter transformation:

Transformation Property	Description
Transformation Name	Name of the transformation.
Transformation Scope	Specifies how the Integration Service applies the transformation logic to incoming data.
Null Treated Low	Treats null values as lower than any other value in a Sorter transformation.
Distinct	Treats output rows as distinct in the Sorter transformation.
Work Directory	Work directory for the Integration Service to create temporary files while it sorts data.
Sorter Cache Size	Maximum amount of memory that the Integration Service can allocate to perform the sort operation.