Accumulating Snapshots

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download Accumulating Snapshots as PDF --


These fact tables represent the complete life of an activity or process, that has a definite beginning and end. They have multiple date dimensions (roles) to refer to the events that occur during a process. These kind of tables are used for to the spans of time between different events (lag calculations).

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Leave a Reply

Your email address will not be published. Required fields are marked *


*