You use this page to associate a table with a Join column and specify a conditional expression. The expression is evaluated for each record captured or copied for distribution for this table mapping. Only records for which the Boolean result is “true” are distributed to the target table; others are not distributed at all.
To associate a table with a Join column:
-
Select a table from the Table dropdown.
-
In the Column dropdown, select and insert the join column.
To define a conditional expression:
-
Use the workbox in this window to specify your Boolean expression. See Expression for gate condition.
-
Optionally, select Keep the target row if UPDATE causes a change in scope to modify how changes in scope are handled.
-
Click the Validate button, and correct any syntax errors.
When you eventually commit the model, a Java method is created for each expression.