TRANSFORMATIONSTATISTICS

Definition

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

Structure

TRANSFORMATIONSTATISTICS

PACKAGEGUID

CHAR(24) BYTE

Unique ID of the transformation package

STEPID

FIXED(6,0)

Ascending number for each transformation package

OWNER

CHAR(32)

Table owner

SCHEMANAME

CHAR(32)

Schema name

TABLENAME

CHAR(32)

Table name

BYTECOUNT

FIXED(11,0)

Size of the DATA data stream in bytes

ROWCOUNT

FIXED(10,0)

Number of table rows in the DATA data stream

TRANSACTIONSSIZE

FIXED(6,0)

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

SYSTEMTIME

FLOAT(38)

Transformation performance

KERNELTIME

FIXED(20,10)

Kernel performance

LOADERTIME

FLOAT(38)

Loader performance

DATATIME

FLOAT(38)

Pager performance

LOGTIME

FIXED(15,10)

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

IOTIME

FIXED(15,10)

Total I/O time within a transformation step

See also:

Additional System Tables