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.