What is a Data Warehouse?
October 25, 2016
What is dimension table in data warehouse?
October 25, 2016
Show all

What is fact table in data warehouse?

Fact table contains numerical values which can be measured. Hence these are also called as measures. Basically, these are nothing but your numbers like

  • what are the total sales which have happened in a store in a day?
  • what are the total number of products which are on discount?
  • what is the percentage of purchase rate for a customer whose is part of the email marketing?
  • how many number of new customers have joined the discount program?
  • how much is being spent on the promotion activities and how much is the sale?
  • what was the average rate of purchase for a particular product during the holiday season?

Though, all these questions have a different answers, the answer will be a number or a numeric value. Which are either derived/calculated or will be used for derivation or calculation for various purposes.

There are different types of fact tables.

Additive Fact: Additive fact is the fact that can be summed up through all the dimensions in the fact table. Sales fact is the example for additive fact.

Semi Additive Fact: Semi additive fact is the fact that can be summed up some of the dimensions in the fact table.

Non Additive Fact: Non additive fact is the fact that can not be summed for any dimension in the fact table.

Fact less Fact table: It is a fact table which will have keys from various dimensions but will not have any facts/measures in it.

Cumulative Fact: It is a fact which will store the data over a period of time.

Snap shot: It is a fact which will store the data at a point of time.

Leave a Reply

Your email address will not be published. Required fields are marked *

Share
+1
Tweet
Pin
Share