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

divakar021

  • 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
      (2*365)*300*200

  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