You can add a join to a mapping group. By using a join, you define
a condition based on the value of the columns that are involved in your source
tables. When you generate an SQL script with the mapping model, the join expression
is used to generate a WHERE clause in the SQL query.
Prerequisite:- Creating a mapping model
- Create mappings between a source and a target, or run the discover function
and accept at least one mapping.
After you create a mapping relationship between a source and a
target, you can define a join condition that can be applied to the target
map.
To add a join condition to the mapping group:
- In the Mapping Group view of the mapping editor, right-click a
mapping line.
- Click to open the Add a Join condition window.
If a join already exists, click to open the Change a Join Condition window.
- Double-click columns in the Columns field
to join columns from each table listed.
- Optional: Select a function type and then double-click
the function to apply to this join.
- If you selected Validate expressions in
the workbench Preferences page, and you see a red wavy underscore to denote
an expression that is not valid, modify the expression to create a valid join
condition.
- Click OK.