Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

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. Comparing Objects
  12. Managing Business Components
  13. Creating Cubes and Dimensions
  14. Using the Mapping Wizards
  15. Appendix A: Datatype Reference

Designer Guide

Designer Guide

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.

0 COMMENTS

We’d like to hear from you!