1. User Guide
  2. Data Quality Framework
  3. Data Quality Rules
  4. Creating Expressions

Creating Expressions

You can define an expression in the Expression Builder to combine two selected tables.

The expression builder includes the following sections:
  • Entities - consists of the Entities folder with the list of tables that you selected from the Entity Groups folder. Double-click the Entities folder to view the selected dimension tables (Product and Segment tables).
  • Functions – The 2 types of functions are,
    • Database Functions - consists of functions that are specific to databases.
    • User Defined Functions - use these functions along with Operators to specify the join condition.
  • Operators - Consists of the function operators categorized into folders. The various types of operators are,
    • Arithmetic - +, -, %, * and /
    • Comparison - '=', '!=', '< >', '>', '<', >=, <=,'IN', 'NOT IN', 'ANY', 'BETWEEN', 'LIKE', 'IS NULL', and 'IS NOT NULL'.
    • Logical - 'NOT', 'AND' and 'OR'
    • Set - UNION, UNION ALL, INTERSECT and MINUS
    • Other - The Other operators are 'PRIOR', '(+)', '(' and ')'.
To specify the join condition:
  1. Select the Entity of the fact table to which you want join the dimension entities.
  2. Select a Function depending on the database type.
  3. Select the Operator you want to use for the join condition.
  4. Select the Second Entity from the Entities pane that you want to join with the first entity. You can also select more than one table and link to the fact table.
    The defined expression is displayed in the Expression pane. Click Reset to reset the values.
  5. Click OK.
    The defined expression is validated as per the selected table and entity definition and on successful validation, it is added to the DQ Rule.