Accumulating Snapshot Fact Table
What has happened throughout the period?
Amazon Order.. what happened at several time intervals.
Order Date
Shipping Date
Est Arrival Date
Fulfilling Date
Delivered Date
As the process moves from one step to another, these get updated.
Accumulating snapshot always has different date fields denoting multiple stages of the process.
Another example: Hospital entry
Here we Insert once and update the rest.
Last updated