WikiSysop: Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_TRANSFORM_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{P..."

2022-06-29T04:30:45Z

Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_TRANSFORM_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{P..."

New page

{{ArticleSimplifiedWikiEdit
|DisplayName=Table CTL_TRANSFORM_HISTORY
|Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}}
}}
{{PDMTable
|tableName = CTL_TRANSFORM_HISTORY
|shortDesc =
|tableDesc = This table provides information about the execution history of Job_TransformGIM.
|subjectAreas =
|introduced =
|modified = 8.5.010 (HWM_VALUE2 column added); 8.5.009 (AUDIT_KEY column added); 8.5.003 (in Oracle, fields with <tt>VARCHAR</tt> data types use explicit <tt>CHAR</tt> character-length semantics)
|discontinued =
|group =
|partitioned = yes
}}

{{PDMColumn
|colName = JOB_ID
|dataType_Ora = VARCHAR2(64 CHAR)
|dataType_MSSQL = varchar(64)
|dataType_Postgre = varchar(64)
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = ID that uniquely identifies the execution instance of the job.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = JOB_VERSION
|dataType_Ora = VARCHAR2(64 CHAR)
|dataType_MSSQL = varchar(64)
|dataType_Postgre = varchar(64)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The version of Job_TransformGIM--for example, 8.1.000.10.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = HWM_NAME
|dataType_Ora = VARCHAR2(255 CHAR)
|dataType_MSSQL = varchar(255)
|dataType_Postgre = varchar(255)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The name of the table from which data was taken for transformation.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = HWM_VALUE
|dataType_Ora = NUMBER(19)
|dataType_MSSQL = numeric(19)
|dataType_Postgre = numeric(19)
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = Provides the value of the numeric high-water mark (HWM) for the records that are processed in a given transformation cycle.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = HWM_VALUE2
|dataType_Ora = VARCHAR2(255 CHAR)
|dataType_MSSQL = varchar(255)/nvarchar(255)
|dataType_Postgre = varchar(255)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = 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.
|introduced = 8.5.010
|modified =
|discontinued =
}}

{{PDMColumn
|colName = TRANSFORM_START_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The date and time when the transformation job started.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = TRANSFORM_END_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The date and time when the transformation job finished.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = ROW_COUNT
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = Provides the number of records that are processed in a given transformation cycle.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = CREATED_TS
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The UTC-equivalent value of the date and time at which the transformation job started.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = AUDIT_KEY
|dataType_Ora = NUMBER(19)
|dataType_MSSQL = numeric(19)
|dataType_Postgre = numeric(19)
|primaryKey =
|mandatory =
|foreignKey = yes
|default =
|colDesc = 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.
|introduced = 8.5.009
|modified =
|discontinued =
}}

{{PDMIndex}}
{{PDMIndexItem
|indexName = I_C_TRANSFORM_H_CTS
|indexDesc = Improves purge performance.
|indexPresentInPartitioned = yes
|indexKey = CREATED_TS
|keyPresentInNonpartitioned = yes
|sort = Ascending
|unique =
|cluster =
}}

{{PDMRef
|parentTable = CTL_AUDIT_LOG
|parentColumn = AUDIT_KEY
|foreignKey = AUDIT_KEY
}}

Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL TRANSFORM HISTORY - Revision history

WikiSysop: Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_TRANSFORM_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{P..."