Your mapping model can include expressions that filter
columns, sort rows, or join tables.
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.
About this task
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.
Procedure
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.