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-d...
----------------------------------------------------------------------------------------------------------------------
- About Big Data Engineering in Depth: https://gability.com/en/courses/big-d...
----------------------------------------------------------------------------------------------------------------------
- About Garage Education: https://gability.com/en/#about
----------------------------------------------------------------------------------------------------------------------
Follow us:
Twitter: Twitter: garageeducation
Facebook: Facebook: GarageEducationCourses
Youtube: garageeducation
Website: http://gability.com/

• #science_technology
• #hadoop
• #big_data
• #dwh
• #spark
• #kafka
• #mdm
• #salable
• #distributed_systems
• #scala
• #data_engineering
• #ai
• #docker
• #automation