Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Accumulating snapshot

2 posters

Go down

Accumulating snapshot Empty Accumulating snapshot

Post  RajiRavi 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?


Posts : 1
Join date : 2010-02-03

Back to top Go down

Accumulating snapshot Empty Re: Accumulating snapshot

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

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

Back to top Go down

Back to top

- Similar topics

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