PowerCenter
- PowerCenter 10.4.0
- All Products
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.
|