You need to have a transformation defined to build a criteria.
- On the Create Mapping <logical model name> page, select the required logical entity, and click the Criteria Builder icon on the tool bar . Alternatively, click the Entity Transformation icon of the required logical entity.
- Select a grouping method for the criteria from the Group satisfying criterion drop-down list. Specify whether it is necessary to fulfill Any, All, or None of the criteria defined in the criteria group.
- 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 build the criteria:
- Click <Column 1> and select the column to which the criteria is to be applied.
-
Click the <Comparison> drop-down list to
select the required logical operator.
Note: You can add multiple criteria to one criteria group. Use the Add Comparison icon to add another criteria to this group, and repeat steps a and b to build the criteria.
- To add a child to this criteria group, click the Add group icon , and repeat steps 3 and 4 to build criteria.
-
Click OK.
The defined criteria are saved and is used to retrieve data from the mapped tables and columns to the logical model.