Logging
Logging is controlled by the /level setting in the batch files. By default, the setting is /level:Basic. You can edit the batch files to change the setting:
Logging Levels
|
Logging Level |
Description |
|---|---|
|
Error |
Only show errors |
|
Nothing |
Don't show any output |
|
Minimal |
Only use minimal logging |
|
Basic |
This is the default basic logging level |
|
Detailed |
Give detailed logging output |
|
Debug |
For debugging purposes; very detailed output |
|
Rowlevel |
Logging at a row level; this may generate a lot of data |
Individual Transformation Logs
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:
|
|
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 |