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