Govur University Logo
--> --> --> -->
...

During the design of a fact table, what is the difference between an 'accumulating snapshot' and a 'periodic snapshot' regarding how they track time-based business metrics?



A periodic snapshot fact table captures the state of a business process at regular, consistent intervals of time. It acts like a recurring status report, recording metrics such as daily account balances, monthly sales totals, or weekly inventory levels. Each row represents a summary of activity over a specific time period, such as a day, week, or month, ....

Log in to view the answer



Community Answers

Sign in to open profiles and full community answers.

No community answers yet. Enroll now and be the first to submit one.

Redundant Elements