|
|
| Line 1: |
Line 1: |
| − | = Table CTL_TRANSFORM_HISTORY =
| |
| | | | |
| − | <onlyinclude>
| |
| − | {{PDMTable
| |
| − | |tableName = CTL_TRANSFORM_HISTORY
| |
| − | |shortDesc =
| |
| − | |tableDesc = This table provides information about the execution history of Job_TransformGIM.
| |
| − | |subjectAreas =
| |
| − | |introduced =
| |
| − | |modified = {{#switch:{{#explode:{{FULLPAGENAME}}|:|2}}
| |
| − | |Library
| |
| − | |PDMOra=8.5.003 (fields with <tt>VARCHAR</tt> data types use explicit <tt>CHAR</tt> character-length semantics)
| |
| − | |#default=}}
| |
| − | |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 highest value of the AUDIT_KEY field for the records that are processed in a given transformation cycle.
| |
| − | |introduced =
| |
| − | |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 =
| |
| − | }}
| |
| − |
| |
| − | {{PDMIndex}}
| |
| − | {{PDMIndexItem
| |
| − | |indexName = I_C_TRANSFORM_H_CTS
| |
| − | |indexDesc = Improves purge performance.
| |
| − | |indexPresentInPartitioned = yes
| |
| − | |indexKey = CREATED_TS
| |
| − | |keyPresentInNonpartitioned = yes
| |
| − | |sort = Ascending
| |
| − | |unique =
| |
| − | |cluster =
| |
| − | }}
| |
| − |
| |
| − | </onlyinclude>
| |
| − |
| |
| − | [[Category:V:GIM:8.5DRAFT]]
| |
