Friday, 11 September 2015

What are the types of Facts?

The types of Facts are as follows.

1.     Additive Facts: A Fact which can be summed up for any of the dimension available in the fact table.
2.     Semi-Additive Facts: A Fact which can be summed up to a few dimensions and not for all dimensions available in the fact table.
3.     Non-Additive Fact: A Fact which cannot be summed up for any of the dimensions available in the fact table.

No comments:

Post a Comment