Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Entering the Data Breakpoint Condition

Entering the Data Breakpoint Condition

When you create a data condition, you enter a global parameter or a parameter for a single transformation. You have different options depending on the selected instance and the type of condition you create.
Use the following syntax when you evaluate a transformation against a port or constant value:
<port> <operator> <type> <value>
Use the following syntax when you check for null and default values, either globally or in a transformation:
<port> <operator>
For a single transformation, you can enter multiple conditions within one breakpoint if you want the Debugger to pause when all the conditions are true. You can also enter multiple breakpoints for a single transformation if you want the Debugger to pause when at least one condition is true.
The following figure shows multiple conditions within a single breakpoint:
The breakpoint contains the following conditions: IN_AVG_PRICE >= [13000] AND OUT_AVG_PROFIT = 10000.
In this example, the Debugger pauses when both conditions are true.
The following figure shows multiple breakpoints within a single transformation:
The condition for Breakpoint 1 is IN_AVG_PRICE >= [13000]. The condition for Breakpoint 2 is OUT_AVG_PROFIT = 10000.
In this example, the Debugger pauses when either condition is true.
The following table describes the condition parameters for transformation and global data breakpoints:
Parameter
Transformation Options
Global Options
Port
Choose port name, <<ROW-ID>>, <<ROW-TYPE>>, or <<ANY-PORT>>.
<ANY-PORT>. You can evaluate this condition against each port in each transformation and mapplet.
Operator
<, <=, =, >, >=, !=, ISNULL, ISDEFAULT.
ISNULL, ISDEFAULT.
Type
Constant, Port. Evaluate against a constant value or another port in the transformation.
Not available.
Value
Enter the value or select the port name.
Not available.


Updated July 02, 2020