Sort Conditions
Configure the sort condition to specify the sort fields and the sort order.
The sort fields are one or more fields that you want to use as the sort criteria. The Mapping Configuration task sorts data according to the fields specified.
Configure the sort order to sort data in ascending or descending order. By default, the Mapping Configuration task sorts data in ascending order.
The session sort order determines the ascending and descending order. You can configure the session sort order when you schedule a Mapping Configuration task, under the advanced session properties.
When you specify multiple sort conditions, the Mapping Configuration task sorts each condition sequentially. The Mapping Configuration task treats each successive sort condition as a secondary sort of the previous sort condition. You can configure the order of sort conditions.
If you use a parameter for the sort condition, define the sort fields and the sort order when you configure the Mapping Configuration task.