Database table WH_EXTRACT_LOG contains an entry for each individual transformation that runs as part of the refresh job. This logging feature captures the number of rows processed for each object in TeamConnect for each run of the Data Warehouse. It also displays the current status of each ETL transformation as well as a date stamp for entries logged.
You can query this table, sorting by column LOGDATE, to retrieve transformation history. Currently there is no limit on the number of entries in the WH_EXTRACT_LOG. It is up to you to maintain the space used by this table. It is recommended that you delete rows periodically, based on LOGDATE value, to recover space.
WH_EXTRACT_LOG column definitions
Column Name |
Usage |
ID_BATCH |
A number that is incremented by one for each transformation run. |
CHANNEL_ID |
Internal identifier used by the Kettle tool. |
TRANSNAME |
The name of the ETL transformation that generated the log entry. This corresponds to the Warehouse table name. |
STATUS |
Indicates the current status of a transformation. Possible values are: •start—indicates the transform has started •stopped—indicates the transform has stopped and not run to completion •end—indicates that the transform has run to completion |
LINES_READ |
Not used by Data Warehouse |
LINES_WRITTEN |
Not used by Data Warehouse |
LINES_UPDATED |
Not used by Data Warehouse |
LINES_INPUT |
The number of rows input from the TeamConnect source |
LINES_OUTPUT |
The number of rows output to the Warehouse |
LINES_REJECTED |
Not used by Data Warehouse |
ERRORS |
The number of errors logged by the transformation. |
STARTDATE |
Not used by Data Warehouse |
ENDDATE |
Not used by Data Warehouse |
LOGDATE |
Date the row was updated in WH_EXTRACT_LOG |
DEPDATE |
Not used by Data Warehouse |
REPLAYDATE |
Not used by Data Warehouse |
