Your mapping model can include expressions that filter columns,
sort rows, or join tables.
Prerequisites:- Creating a mapping model
- Create mappings between a source and a target, or
run the discover function and accept at least one mapping.
The expression builder creates expressions that you use as part
of the mapping model. You can then generate the mapping model into SQL statements
that include these filters, sort conditions, or join conditions.
To
build an expression in the mapping model:
- Right-click a mapping model to open the mapping editor.
- In the Mappings field in the mapping editor, click the View options
icon and select the Mapping Groups menu option. The mapping
editor changes to display mappings at the table level.
- Right-click on a mapping line and select the menu item for the
type of expression that you want to create.