Creating a Criterion
-
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.