InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are The Types Of Facts? |
|
Answer» The types of Facts are: ADDITIVE Facts: - A Fact which can be SUMMED up for any of the dimension available in the Fact Table. Semi-Additive Facts: - A Fact which can be summed up to a few DIMENSIONS and not for all dimensions and not for all dimensions available in the Fact Table. Non-Additive Fact: - a fact which cannot be summed up for any of the dimensions available in the Fact Table. The types of Facts are: Additive Facts: - A Fact which can be summed up for any of the dimension available in the Fact Table. Semi-Additive Facts: - A Fact which can be summed up to a few dimensions and not for all dimensions and not for all dimensions available in the Fact Table. Non-Additive Fact: - a fact which cannot be summed up for any of the dimensions available in the Fact Table. |
|