Types of Facts | Data Warehouse Concepts
In this tutorial, we will walk through different types of fact. The nature of aggregation of facts for dimensions divides Facts into 3 groups that we can call 3 different fact types:
1. if fact can be summed up for all dimensions in then it is called Additive Fact.
2. if it can be summed up for some dimensions in table but not all then it is semi-additive fact and
3. if it cannot be summed up for any of the dimensions present in the table then it is non-additive fact.
Видео Types of Facts | Data Warehouse Concepts канала aroundBI
1. if fact can be summed up for all dimensions in then it is called Additive Fact.
2. if it can be summed up for some dimensions in table but not all then it is semi-additive fact and
3. if it cannot be summed up for any of the dimensions present in the table then it is non-additive fact.
Видео Types of Facts | Data Warehouse Concepts канала aroundBI
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Why Surrogate Keys are used in Data WarehouseHandle Late Arriving Dimensions|Early Arriving Fact|Dimensional Modeling TechniquesSCD - Slowly Changing Dimension in Data Warehouse7 Different Types of Dimensions in a Data Warehouse!Explain Star Schema & Snow Flake DesignTypes of Fact Tables in Data Warehouse | Transaction, Periodic and AccumulatingUse of Degenerate Dimension | Data warehouse ConceptsWhy Conformed Dimension is so important | Data Warehouse ConceptsWhy do we need Junk Dimension | Data Warehouse ConceptsFact Tables and Types of fact tablesWhat is Grain in Data warehouseWhat is a Data Warehouse - Explained with real life example | datawarehouse vs database (2020)SCD: Slowly changing dimensions explained with real examplesHow Merged Dimension Works | SAP BusinessObjectsWhat is ETL | What is Data Warehouse | OLTP vs OLAPBasic Concept of Database Normalization - Simple Explanation for BeginnersDWH Interview Question :Number of fact and Dimension table in project|TechCoachData Warehouse Schema – Star, Snowflake and Fact Constellation, Adv. and Disadv.Data Warehouse Interview Questions And Answers | Data Warehouse Tutorial | EdurekaData Warehousing Interview Questions | Dimensions | Aggregate Tables | Factless Fact