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:
Data Warehouse Design Tip: Use both EFFECTIVE_START_DATE and EFFECTIVE_END_DATE to support the SCD Type 2 table.