Table CTL_TRANSFORM_HISTORY
In the Column List:
- P = Primary key
- M = Mandatory field
- F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
- DV = Default value
- For Microsoft SQL Server, varchar/nvarchar in the Data Type column means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in cloud deployments is not multi-language.) THIS BULLET WILL DISPLAY ONLY IN THE PE MSSQL PDM.
Contents
Description
This table provides information about the execution history of Job_TransformGIM.
Column List
Column | Data Type | P | M | F | DV |
---|---|---|---|---|---|
JOB_ID | varchar(64) | X | |||
JOB_VERSION | varchar(64) | ||||
HWM_NAME | varchar(255) | ||||
HWM_VALUE | numeric(19) | X | |||
HWM_VALUE2 | varchar(255) | ||||
TRANSFORM_START_TIME | timestamp(3) | ||||
TRANSFORM_END_TIME | timestamp(3) | ||||
ROW_COUNT | integer | ||||
CREATED_TS | integer | X | |||
AUDIT_KEY | numeric(19) | X |
JOB_ID
ID that uniquely identifies the execution instance of the job.
JOB_VERSION
The version of Job_TransformGIM--for example, 8.1.000.10.
HWM_NAME
The name of the table from which data was taken for transformation.
HWM_VALUE
Provides the value of the numeric high-water mark (HWM) for the records that are processed in a given transformation cycle.
HWM_VALUE2
Introduced: Release 8.5.010
Provides supplemental information about the value of HWM_VALUE, when applicable.
The column was introduced to support future alternative data streams in which the HWMs might require nonnumeric values for context.
TRANSFORM_START_TIME
The date and time when the transformation job started.
TRANSFORM_END_TIME
The date and time when the transformation job finished.
ROW_COUNT
Provides the number of records that are processed in a given transformation cycle.
CREATED_TS
The UTC-equivalent value of the date and time at which the transformation job started.
AUDIT_KEY
Introduced: Release 8.5.009
The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key is used for data lineage purposes, in particular to identify the HWM_VALUE or HWM_VALUE2 related to a particular audit key.
Index List
CODE | U | C | Description |
---|---|---|---|
I_C_TRANSFORM_H_CTS | Improves purge performance. |
Index I_C_TRANSFORM_H_CTS
Field | Sort | Comment |
---|---|---|
CREATED_TS | Ascending |
Subject Areas
References
The summary List of References will include the following entries for this table or view:
Child Table/View | Child Table/View Column | Parent Table/View | Parent Table/View Column |
---|---|---|---|
CTL_ |
AUDIT_KEY | CTL_ |
AUDIT_KEY |