1. Addictive Type:
Measurements in a fact table that can be summed up across all dimensions
Consider the following retail fact table:
.png)
Store wise sales
.png)
Product wise sales
.png)
Daily Sales
.png)
2. Semi Addictive Fact:
Measurements in a fact table that can be summed up across only a few dimensions keys Following table is used to record current balance and profit margin for each id at a particular instance of time (Day end)
Subscribe to our youtube channel to get new updates..!
In the above table, we cannot sum up current balance across Acct Id
If we ask balance for Id 21653 we will say that 22000, not 22000+80000
Checkout Informatica Interview Questions
3. Non-addictive fact:
Facts that cannot be summed up across any dimension key
Note: % and ratio columns are non-addictive facts
Related Blog: Snowflake vs Redshift
4. Factless fact table:
A fact table without any measures is called the factless fact table
-
It contains only keys
-
It acts as a bridge between dimension keys
