When we need to track the values of some measurements at regular, predictable time intervals, we can use periodic snapshots. Instead of having a row for each event we take a picture (snapshot) of the activity at the end of the day, week, or month. Sometimes, periodic snapshots are just an aggregation of the transactions that occurred during a time period, however they have more predictable sparseness as there is one row of facts generated for each combination of the dimensions that it refers to. Periodic snapshots are suited for tracking long-running processes.
All data and information provided on this blog is for informational purposes only. Opinions expressed here are entirely my own and not of my employer.
- SAP Data Services (54)
- Map_Operation Transform (37)
- What is RDBMS? (33)
- Lookups in SAP BODI/DS (21)
- Tip of the day - Pushdown_sql() (20)
- SAP Data Services (26)
- What is RDBMS? (25)
- List of ETL Tools (15)
- Map_Operation Transform (13)
- SCD - Slowly Changing Dimensions (10)