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