Big Data Engineering In Depth - Ch.02-29 Fact Tables | Data Modeling | DWH Architecture

In this episode, we explain the following topics. - What is the Fact table? - What is Grain and Fact Granularity? - What are the Types of Facts tables? - Transaction Fact Table. - Periodic Fact Table. - Accumulated Snapshot Fact table. - What is the Fact types? - Additive. - Semi-Additive. - Non-Additive. - Textual. - Derived. - Factless. ---------------------------------------------------------------------------------------------------------------------- Lecture Notes: https://gability.com/en/courses/big-data-in-depth/02-dwh/03-architecture/10-data-modeling/03-fact-tables/ ---------------------------------------------------------------------------------------------------------------------- - About Big Data Engineering in Depth: https://gability.com/en/courses/big-data-in-depth/ ---------------------------------------------------------------------------------------------------------------------- - About Garage Education: https://gability.com/en/#about ---------------------------------------------------------------------------------------------------------------------- Follow us: Twitter: https://twitter.com/garageeducation Facebook: https://www.facebook.com/GarageEducationCourses/ Youtube: https://www.youtube.com/c/GarageEducation Website: http://gability.com/