ETL for Accumulating Snapshot
2 posters
Page 1 of 1
ETL for Accumulating Snapshot
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?
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?
spaul- Posts : 10
Join date : 2010-08-24
Re: ETL for Accumulating Snapshot
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.
hang- Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia
Similar topics
» Can you combine an accumulating and periodic snapshot into a single accumulating periodic snapshot table?!
» Incremental Accumulating Snapshot ETL
» Accumulating snapshot with SCD?
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» Fact table type
» Incremental Accumulating Snapshot ETL
» Accumulating snapshot with SCD?
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» Fact table type
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum