How can we calculate the fact table size?

Questions by sridhar.gonda   answers by sridhar.gonda

Showing Answers 1 - 2 of 2 Answers

nandu214

  • Jun 17th, 2008
 

Hi we can calculate the size depending upon how much period and how many products for how many customers information u want to store like this we calculate the fact table size.

Ex:- if we have 100 customers and 200 products for 5 years of data for this the fact table size is

(5*365)*100*200 this is the fact table size

Note: here consider 365 days for a year 

Hope this may helps

if u cant clear mail me

  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