TRANSFORMATIONPACKAGES

Definition

The system table TRANSFORMATIONPACKAGES contains all steps of a Loader transformation for a transformation package.

Structure

TRANSFORMATIONPACKAGES

PACKAGEGUID

CHAR(24) BYTE

Unique ID of the transformation package

TASKID

FIXED(6.0)

ID of the transformation task

STEPID

FIXED(6.0)

ID of the transformation step

OWNER

CHAR(32)

Table owner

SCHEMANAME

CHAR(32)

Schema name

TABLENAME

CHAR(32)

Table name

EXCLUDE

BOOLEAN

Transformation step was excluded (TRUE) or not (FALSE)

RESTART

BOOLEAN

Transformation step was executed (TRUE) or not (FALSE)

See also:

Additional System Tables