Adding a join to the mapping group

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

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:

  1. In the Mapping Group view of the mapping editor, right-click a mapping line.
  2. Click Join > Add to open the Add a Join condition window. If a join already exists, click Join > Change to open the Change a Join Condition window.
  3. Double-click columns in the Columns field to join columns from each table listed.
  4. Optional: Select a function type and then double-click the function to apply to this join.
  5. 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.
  6. Click OK.

Feedback