|Maintenance Notice - PDF Generation|
|Dynamic PDF generation for web-based content is temporarily unavailable. This maintenance affects dynamic PDF files that are generated from either the HTML-based page or manual that you are viewing. Links that normally allow this functionality have been hidden, and will reappear as soon as the feature is restored.
The ETL_AUDIT table records information about every iWD Data Mart ETL job that has been executed. Various ETL jobs use the information stored in this table to determine when task processing ended from the last run of the job and thus, where to resume processing.
|ETL_AUDIT_KEY||int||Primary key of this table.|
|ETL_AUDIT_TIME||datetime||Date and time when the job finished running.|
|BATCH_ID||int||Batch number, for jobs that process data in batches (such as GTL_DM_load_intraday). Each batch job has its own ETL audit record.|
|DATA_SOURCE_TYPE||varchar(16)||Primary source of the job data; either config, task, or datamart. (Data from the Interaction Server Events Log database is classified as task data source type.)|
|DATA_SOURCE_NAME||varchar(1000)||Database ID (equals database JDBC URL).|
|PROCESS_NAME||varchar(255)||The name of the job that is processing the records (such as, load_config).|
|FIRST_EXTRACTED_EVENT_ID||int||ID that starts the range of event IDs that are processed.|
|LAST_EXTRACTED_EVENT_ID||int||ID that ends the range of event IDs that are processed.|
|BATCH_LAST_EVENT_ID||int||ID of the last event in the batch. Used to set the starting point for the next batch.|
|LAST_INTERVAL_DATE_KEY||int||Last date interval that is processed by the aggregate ETL scripts.|
|LAST_INTERVAL_TIME_KEY||int||Last time interval that is processed by the aggregate ETL scripts.|