This is my first time implmenting an accumulating snapshot fact table and I require some guidance.
Accumulating snapshot fact tables show the status at any given moment. It
is useful to track items with certain life time, for example: status of order lines.eg everytime there is new piece of information about a particular purchase, we update the fact
table record. We only insert a new record in the fact table when there is a new purchase requisition.
What I really need to know is how best to handle the updates.
This really feels very similar to managing SCD-1's in dimension processing! Anyone able to advise?
thanks in advance
Here is a perfect example we can use
Figure 1, below, shows an accumulating snapshot for the mortgage application process. The grain of this fact table is an application. Each application will
be represented by a single row in the fact table. The major milestones are represented by multiple foreign key references to the Day dimension—the date of submission, the date approved by mortgage officer, the date all supporting documentation was complete,
the date approved by an underwriter, and the date of closing.
View Complete Post