Configure the sort condition to specify the sort fields and the sort order. The mapping task uses the sort condition to sort the data.
The sort fields are one or more fields that you want to use as the sort criteria. Configure the sort order to sort data in ascending or descending order. In advanced mode, you can override the sort order using the advanced session properties when you schedule the mapping task.
When you specify multiple sort conditions, the mapping task sorts each condition sequentially. The mapping 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 run the mapping or when you configure the mapping task.