The Criteria section is displayed for the selected logical
model entity only if at least one transformation is defined for it.
-
On the Create Mapping <logical model name> page,
select the required logical entity, and click the Criteria
Builder icon on the tool bar .
Note: The Transformation panel doesn't display details of the physical model table. In case you click a physical model table after an entity and open the Transformation panel, it displays details of the last selected entity.The Criteria Builder for logical table <name of the table> pop-up window is displayed, with the Group satisfying criterion drop-down list.Note: To add another group, hover the mouse on the group and click the Add group icon that is displayed.
- Select a grouping method for the criteria by clicking on Group satisfying criterion drop-down list. Specify whether it is necessary to fulfill all, at least one, or none of the criteria defined in the criteria group.
- To add a child group to the parent group, hover the mouse on the parent group and click the Add group icon that is displayed.
-
To add a criterion to a group, hover the mouse on the parent group, and click
the Add Comparison icon . The added criterion shows below the group.
- To define the left operand of the criterion, in the Expression Builder, click <Column 1> to select one of the physical table columns.
-
To select a logical operator from the provided list, in the
Expression Builder, click
<comparison>.
If the selected logical operator requires a right operand, a placeholder for the right operand is displayed to be defined.
-
If the right operand is required, click <Column
2>.
The right operand can be defined using either a constant or a physical model table column.
- Constant
- Enter the constant, and click Add constant.
- column(s)
- Select one of the available physical model columns.
- A constant
- A set of constants
- A column of any of the physical model tables
- A set of columns of any of the physical model tables
- Repeat steps 3 and 4 as many times as is required to create the desired criteria.
- Click OK.
All, any, or none of the defined set of child criteria need to hold true in order to
retrieve the required data from the connected physical model tables into the target
logical model columns. This is as defined for the parent criterion.