Periodic snapshot tables record the cumulative performance of the business at predefined periods of time. A predetermined interval for taking snapshots is the key: daily, weekly, monthly, etc. The results are saved in the periodic snapshot fact table. This can be sometimes in the same fact table or this also being moved into different tables based on the volumes and the design for the reporting purposes.
In this type of Fact tables, we
can incorporate any information that describes activity over a period of time
like daily, weekly, monthly, etc. Just as transaction fact tables have
many dimensions, the snapshot usually has fewer dimensions which lead it not to
have the lower grain of data.
This kind of Fact data will help
in answering the questions like, How many days does a customer carry a positive
account balance in one month? OR What is the average balance of a specific type
of customer each month? Etc.
No comments:
Post a Comment
If you have any doubt, please let me know.