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:
Non additive fact is the fact that can not be summed for any dimension in the fact table.
Fact less 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:
Cumulative Fact:
It is a fact which will store the data over a period of time.
Snap shot:
Snap shot:
It is a fact which will store the data at a point of time.
No comments:
Post a Comment