Timespan Fact Tables
84 بار بازدید -
2 ماه پیش
-
Timespan Fact Tables provide a
Timespan Fact Tables provide a structured approach to handling historical data within fact tables by capturing the timespan when each fact row was effective.
In this informative talk, we delve into the practical application of Timespan Fact Tables. We'll explore the concept of adding a row effective date, row expiration date, and a current row indicator to fact tables, much like the approach used for type 2 slowly changing dimensions.
By doing so, we enable a granular understanding of when facts come into play, change, or expire.
Speaker: Tino Zishiri https://SQLBits.com/speakers/Tino_Zis... Blog: https://adatis.co.uk/author/tinozishiri/
https://SQLBits.com/Sessions/Timespan...
Tags:
In this informative talk, we delve into the practical application of Timespan Fact Tables. We'll explore the concept of adding a row effective date, row expiration date, and a current row indicator to fact tables, much like the approach used for type 2 slowly changing dimensions.
By doing so, we enable a granular understanding of when facts come into play, change, or expire.
Speaker: Tino Zishiri https://SQLBits.com/speakers/Tino_Zis... Blog: https://adatis.co.uk/author/tinozishiri/
https://SQLBits.com/Sessions/Timespan...
Tags:
2 ماه پیش
در تاریخ 1403/04/11 منتشر شده
است.
84
بـار بازدید شده