Table of Contents


  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
  17. Datatype Reference
  18. Configure the Web Browser

Monitoring Transformation Data

Monitoring Transformation Data

When the Debugger pauses, it displays the current row of data in the Instance window for the transformation in the mapping or mapplet where the Integration Service encountered the break. This is the current transformation. You can view the data of any transformation at the point where the Debugger pauses by selecting another transformation from the list in the Instance window.
If you did not select any mapplet to debug after completing the Debugger Wizard, you cannot monitor or view transformations inside the mapplet when the Debugger runs.
Click Tools > Options > Debug tab to select columns to display in the Debugger Data Display window. For more information about displaying columns, see Configuring Debug Options.
When the mapping contains a Custom transformation, the Instance window displays information for ports in all input and output groups.
You can display the following information in the Instance window:
  • Port name.
    Displays all ports that are connected to another transformation or target.
  • RowID.
    Displays row number passing through the transformation.
  • Value.
    Displays the value for each port. If the port contains binary data, this column displays <raw data>. If the port does not contain data, or if it is NULL, this column displays <no data available>. For Router transformations, the values display for input ports and output ports that meet the group condition. Output ports that do not meet the group condition display <no data available> in the value column.
  • Datatype.
    Displays the datatype of the port.
  • Length/precision and scale.
    Displays the length/precision and scale of the port.
  • Null indicator.
    If a column contains a null value, the null indicator column is selected, and the value displays <no data available>.
  • Row type.
    Insert, update, delete, reject, filtered, or not applicable. <<ROW TYPE>> displays in the Port column, and the row type value displays in the Value column. The row type does not display if it is not applicable, such as with Sequence Generator transformations.
  • Port indicator.
    Displays one of the following indicators next to the port name:
    • Current row.
      Indicates the port is in the current row.
    • Previous row.
      Indicates the port is in the previous row.
    • Current row, default value.
      Indicates the value for the column in the current row is the default value.
    • Previous row, default value.
      Indicates the value for the column in the previous row is the default value.
    • Current row, modifiable.
      Indicates an output port in the current row that you can modify.
    Move the pointer across the port indicator to display tooltips about the indicator.
When the Instance window displays the current transformation or any transformation in the pipeline before the current transformation, the current rows display. If you view a transformation in the Instance window that appears in the pipeline after the current instance, the previous rows display. An indicator also displays beside the port name to designate the current or previous row.
For example, in the following mapping, FILTRANS is the current transformation, as shown by the current transformation indicator. When you view the Instance window for FILTRANS or SQ_ORDERS, you see the current row. If you switch to EXPTRANS, you see the previous row because the Integration Service has not processed the current row through EXPTRANS.
The following figure shows transformations with port processing indicators:
The mapping includes the Orders source, SQ_ORDERS, FILTRANS, and EXPTRANS transformations, and the T_ORDERS target. FILTRANS appears with the current transformation indicator.
Current and previous row indicators can also show when the Instance window displays the default value. The Debugger uses the same rules to display the default value indicator in the Instance window that it uses to evaluate default values for breakpoints.
The Debugger does not immediately drop rows flagged to drop. This includes invalid, error, and filtered rows. The Integration Service sets the ROW_FLAG to NULL and designates the row type by a negative number, such as -3 (error). You see the error indicators in the session logs with verbose data tracing only. The Integration Service drops the rows later in the pipeline.

Updated June 25, 2018