Accumulating snapshot

View previous topic View next topic Go down

Accumulating snapshot

Post  RajiRavi on Wed Feb 03, 2010 12:24 pm

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

View user profile

Back to top Go down

Re: Accumulating snapshot

Post  BoxesAndLines on Wed Feb 03, 2010 8:45 pm

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum