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
- Create a mapping model.
- Create mappings between a source and a target, or run the discover
function and accept at least one mapping.
Procedure
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.