Fact table size calculation

How to calculate fact table size.........and how to find fact granularity? Please tell me answers to these 2 questions..

Questions by harikadsc

Showing Answers 1 - 2 of 2 Answers


  • Oct 7th, 2010

A Fact table is calculated based on "lowest level granualarity".
        The  lowest level granualarity can be determined from the dimension table (lowest level in each hierarchy).
eg:- 2 years of historical data for 300 products of 200 stores can be calculated as

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions