Accumulating snapshot
2 posters
Page 1 of 1
Accumulating snapshot
I would like to design a dimension model for an organization's training data. The main report would be to generate transcript for the employee, which will include what he/she has taken including what he should take during his/her employment period. This report should also, track any changes in the employee information such as his promotion to supervisor etc. Will an accumulating snapshot fact with a SCD employeed dimension help in this kind of reporting. Should the SCD key be updated in the accumulating fact table to accomplish this?
RajiRavi- Posts : 1
Join date : 2010-02-03
Re: Accumulating snapshot
It would seem to me that an accumulating snapshot would be too restrictive in the events you are trying to track. Accumulating snapshots are good at tracking well defined events within a workflow process. I would look at a transaction fact approach.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Can you combine an accumulating and periodic snapshot into a single accumulating periodic snapshot table?!
» Accumulating Snapshot and Transaction Snapshot
» Accumulating Snapshot that acts like a SCD
» Accumulating snapshot with SCD?
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» Accumulating Snapshot and Transaction Snapshot
» Accumulating Snapshot that acts like a SCD
» Accumulating snapshot with SCD?
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum