Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Appendix A: Session Properties Reference
  17. Appendix B: Workflow Properties Reference

Workflow Basics Guide

Workflow Basics Guide

Source and Target Statistics

Source and Target Statistics

The Source/Target Statistics area displays information about the rows the Integration Service read from the sources and the rows it loaded to the target.
The following table describes the attributes that appear in the Source/Target Statistics area:
Attribute Name
Description
Transformation Name
Name of the source qualifier instance or the target instance in the mapping. If you create multiple partitions in the source or target, the Instance Name displays the partition number. If the source or target contains multiple groups, the Instance Name displays the group name.
Node
Node running the transformation.
Applied Rows
For sources, shows the number of rows the Integration Service successfully read from the source. For targets, shows the number of rows the Integration Service successfully applied to the target.
For example, you have a target table with one column called SALES_ID and five rows that contain the values 1, 2, 3, 2, and 2. You have a source table with one column called SALES_ID_IN and five rows that contain the values 1, 2, 3, 4, and 5. You mark rows for update where SALES_ID_IN is 2. The Integration Service applies one row, which updates three rows in the target. If you mark rows for update where SALES_ID_IN is 4, the Integration Service applies one row. The Integration Service does not update any rows at the target as the target does not contain rows with SALES_ID as 4.
For a recovery session, this value lists the number of rows that the Integration Service affected or applied to the target after recovery. To determine the number of rows processed before recovery, see the session log.
Affected Rows
For sources, shows the number of rows the Integration Service successfully read from the source.
For targets, shows the number of rows affected by the specified operation. For example, you have a table with one column called SALES_ID and five rows that contain the values 1, 2, 3, 2, and 2. You mark rows for update where SALES_ID is 2. The Integration Service updates three rows, even though there was one update request. If you mark rows for update where SALES_ID is 4, the Integration Service updates no rows.
For a recovery session, this value lists the number of rows that the Integration Service affected or applied to the target after recovery. To determine the number of rows processed before recovery, see the session log.
Rejected Rows
Number of rows the Integration Service dropped when reading from the source, or the number of rows the Integration Service rejected when writing to the target.
Throughput (Rows/Sec)
Rate at which the Integration Service read rows from the source or wrote data into the target per second.
Throughput (Bytes/Sec)
Estimated rate at which the Integration Service read data from the source and wrote data to the target in bytes per second. Throughput (Bytes/Sec) is based on the Throughput (Rows/Sec) and the row size. The row size is based on the number of columns the Integration Service read from the source and wrote to the target, the data movement mode, column metadata, and if you enabled high precision for the session. The calculation is not based on the actual data size in each row.
Bytes
Total bytes processed in the PowerCenter Integration Service memory for the source and target.
Last Error Code
Error message code of the most recent error message written to the session log. If you view details after the session completes, this field displays the last error code.
Last Error Message
Most recent error message written to the session log. If you view details after the session completes, this field displays the last error message.
Start Time
Time the Integration Service started to read from the source or write to the target.
The Workflow Monitor displays time relative to the Integration Service.
End Time
Time the Integration Service finished reading from the source or writing to the target.
The Workflow Monitor displays time relative to the Integration Service.

0 COMMENTS

We’d like to hear from you!