Question: what is periodic snapshot fact table?
Answer: A row in a periodic snapshot fact table summarizes many measurement events occurring over a standard period, such as a day, a week, or a month. ... Periodic snapshot fact tables often contain many facts because any measurement event consistent with the fact table grain is permissible.