The system table TRANSFORMATIONPACKAGES contains all steps of a Loader transformation for a transformation package.
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