Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Late Arriving Facts

Late Arriving Facts refers to a situation that you need to insert or update the historical fact data. It is discussed in Ralph Kimball’s article:

Backward in Time, published in the Intelligent Enterprise magazine.

The handling of Late Arriving Facts is quite simple. The only tricky part is to find the effective warehouse surrogate key back in time.

This leads to the following Design Tips:

ETL Design Tip: Lookup the warehouse surrogate key based on the nature key and the specific date passed from the fact staging table.

Data Warehouse Design Tip: Use both EFFECTIVE_START_DATE and EFFECTIVE_END_DATE to support the SCD Type 2 table.