TRANSFORMATIONMONITOR

Definition

The system table TRANSFORMATIONMONITOR describes the resource consumption of a Loader transformation.

Structure

TRANSFORMATIONMONITOR

PACKAGEGUID

CHAR(24)

Unique ID of the transformation package

ROWCOUNT

FLOAT(38)

Number of transformed rows

TRANSACTIONSIZE

FIXED(6,0)

Minimum number of rows that are to be transformed before the status of the transformation step is logged

SYSTEMDURATION

FLOAT(38)

System performance

KERNELDURATION

FLOAT(38)

Kernel performance

LOADERDURATION

FLOAT(38)

Loader performance

DATADURATION

FLOAT(38)

Pager performance

LOGDURATION

FLOAT(38)

Total time required for the management of actions within a transformation step

IODURATION

FLOAT(38)

Total I/O time within a transformation step

See also:

Additional System Tables