Jump to: navigation, search

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
  • In the Data Type column, varchar/nvarchar 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.)

Table CTL_TRANSFORM_HISTORY

Description

Modified: 8.5.010 (HWM_VALUE2 column added); 8.5.009 (AUDIT_KEY column added)

In partitioned databases, this table is partitioned.


This table provides information about the execution history of Job_TransformGIM.

Column List

Legend

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)/nvarchar(255)

TRANSFORM_START_TIME

datetime

TRANSFORM_END_TIME

datetime

ROW_COUNT

int

CREATED_TS

int 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

No subject area information available.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 29 August 2016, at 15:01.