ETL for Accumulating Snapshot

View previous topic View next topic Go down

ETL for Accumulating Snapshot

Post  spaul on Tue Aug 24, 2010 4:12 pm

I'm looking for a book, sql code, web links, anything to get me started on creating the ETL for an Accumulating Snapshot fact table. I've not yet been able to attend the Kimball ETL class (but the Dimensional Modeling class was great!).

Does anyone know if the Kimball ETL book or class offers some in-depth help with the Accumulating Snapshot fact tables or is the focus on transaction-based fact tables?


Posts : 10
Join date : 2010-08-24

View user profile

Back to top Go down

Re: ETL for Accumulating Snapshot

Post  hang on Mon Aug 30, 2010 7:52 pm

There is a brief discussion in Kimball’s “The Data Warehouse ETL Toolkit” (p222). Basically your ETL will periodically revisit the records and update their various date keys and other dimension keys and measures relevant to the milestones at the point of snapshot until the lifecycle reaches the end for the records.


Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

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