The system table TRANSFORMATIONMONITOR describes the resource consumption of a Loader transformation.
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