After you create a mapping relationship between a source and a
target, a mapping group is automatically created. You can define a sort on
the target columns in the mapping group to refine the ORDER BY predicate that
is created in the generated script.
Before you begin
Prerequisite:- Creating a mapping model
- Create mappings between a source and a target, or run the discover function
and accept at least one mapping.
About this task
To add a sort condition to the mapping group:
- In the Mapping Group view of the mapping editor, right-click a
mapping line.
- Select one or more columns from the Available Columns pane
and click the arrows to add the columns to the Selected Columns pane.
- In the Selected Columns pane, select the
current value in the Order column to change the order. The values are ASC
or DESC for ascending or descending.
- Click OK to add the sort expression to the
target column.