Tuesday, July 12, 2016

Fact Tables in Data Warehouse:


Fact Table in Data Warehouse:

Fact Table: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.

No comments:

Post a Comment