Home  >  Blog  >   Data Warehousing  > 

Types Of Facts In Data Warehouse

Rating: 4
  
 
8930

1. Addictive Type:

Measurements in a fact table that can be summed up across all dimensions

Consider the following retail fact table:

Addictive TypeStore wise sales

Store wise sales

Product-wiseMindMajix Youtube Channel sales

Product wise sales

 

Daily Sales

Daily Sales

Relateed 

[Related Article: Trending Data Warehouse Tools]

Enhance your IT skills and proficiency in Data Warehousing by taking up the  Informatica Training.

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)

Semi Addictive Fact

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

Explore Informatica Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

 

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
Snowflake TrainingJan 31 to Feb 15
Snowflake TrainingFeb 04 to Feb 19
Snowflake TrainingFeb 07 to Feb 22
Snowflake TrainingFeb 11 to Feb 26
Last updated: 28 January 2023
About Author
Remy Sharp
Ravindra Savaram

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.