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.
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
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.
Procedure
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.