Creating a Criterion - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
First publish date
2007
Last updated
2024-02-07
Published on
2024-02-07T17:21:58.768552
The Criteria section is displayed for the selected logical model entity only if at least one transformation is defined for it.
  1. 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.
  2. 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.
  3. 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.
  4. 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.
    1. To define the left operand of the criterion, in the Expression Builder, click <Column 1> to select one of the physical table columns.
    2. 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.
    3. 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.
      Based on the number of operands the logical operator expects in the right operand, define the right operand as any of these:
      • 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
  5. Repeat steps 3 and 4 as many times as is required to create the desired criteria.
  6. 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.