193 ) Types of Fact tables amnd facts

 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~ 

Types of Fact tables

 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~ 

1.     Transactional Fact Tables
Transactional fact tables are designed to capture individual business events or transactions.

2. Periodic Snapshot Fact Tables
Periodic snapshot fact tables provide a summarized view of metrics over regular time intervals.

3. Accumulating Snapshot Fact Tables
Accumulating snapshot fact tables are designed to track the stages of a business process or workflow.

 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~ 

4. Factless facts

 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~ 

 7 What is factless fact table A factless Most of the columns are empty.

Such dimensions are called sparse dimensions fact table is a table that contains only foreign keys to dimensions,

but no numeric facts.

Factless fact tables are used to capture events or situations that have no measurable outcome

 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~ 

types of fact tables 51

  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~ 

1. Additive 
    ( can be added like total qty , sales ) 
2. Semi additive
     ( cannot be added but updated like account balance )  
3. Non Additive 

    ( numerical but cannot be added like today price  of stock )