Data warehouse

Fact Table in Data Warehouse

The fact table that contains numerical values of what we measure. There are different types of fact tables are there.
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.

Powered by Blogger.