Data Warehouse ETL Status Update Table

The ETL load status update table is one of the must have tabele in DW, the table should maintain staging and target load start and end time with most recent load indicator

here is an example,




This example describe the staging and target load start and end time for customer data. the MOST_REC_LOAD_IND field should be "Y" for the most recent process date and "N" for the history date. This field can be used as a trigger to run the report automatically once the data gets loaded.