Using Criteria Builder

You need to have a transformation defined to build a criteria.
  1. 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.
  2. 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.
  3. 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.
  4. To build the criteria:
    1. Click <Column 1> and select the column to which the criteria is to be applied.
    2. 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.
  5. To add a child to this criteria group, click the Add group icon , and repeat steps 3 and 4 to build criteria.
  6. Click OK.
    The defined criteria are saved and is used to retrieve data from the mapped tables and columns to the logical model.