English
  • PowerCenter 10.2 HotFix 1
  • All Products

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

Designer Guide

Designer Guide

Back Next

Using ISNULL and ISDEFAULT

Using ISNULL and ISDEFAULT

You can create ISNULL and ISDEFAULT conditions in transformation and global data breakpoints. When you use the ISNULL or ISDEFAULT operator, you cannot use the type or value in the condition.
When you create an ISNULL condition, the Debugger pauses when the Integration Service encounters a null input value, and the port contains the system default value.
When you create an ISDEFAULT condition, the Debugger pauses in the following circumstances:
  • The Integration Service encounters an output transformation error, and the port contains a user-defined default value of a constant value or constant expression.
  • The Integration Service encounters a null input value, and the port contains a user-defined default value of a constant value or constant expression.