Detailed notes for this lesson are being written. They appear here together with the video.
Video coming soonThis lesson’s video is being made
Start with the notes below; the video appears here as soon as it is on YouTube.
SQL and Databases · Lesson 75 of 90
Fact table types and slowly changing dimensions
transactional fact tableperiodic snapshot fact tableaccumulating snapshot fact tablefactless fact tableadditive / semi-additive / non-additive measureslowly changing dimension (SCD)SCD Type 0Type 1Type 2Type 3Type 4Type 6effective_fromeffective_to