Sahadevan

• Sep 22nd, 2006

 

HiIs it enterprises data warehouse ?

Sahadevan

• Sep 22nd, 2006

 

Hi

Please let me know which data type used .

sahadevan

hari

• Nov 25th, 2006

 

if the cube size is 80gb and the time period is 1 day then total amount of record in that infocube is 7crore recors will be there.

chandra nayak

• Dec 16th, 2006

 

I do not think it has the complete information. If the fact has 200 attributes vs if it has 10 attributes will it have the same number of records?

Guest

• Jan 22nd, 2007

 

Not possible to estimate. But generally Facts occupy 90% space in database.

Are Ramakrishna Rao

• Aug 14th, 2007

 

The estimation process is as follows

1. We have to estimate the size table wise
     for example one fact table having say 50 cols. one of the col size is varchar 200.
    we have to take all col sizes and find the maximum length of each record.
    Take the required column sizes and find the minimum length of each record.

     Find the average and multiply with the number of records available in the fact table.

2. we can also estimate future growth, table wise
    
     Take 3 to 4 years data. Find the increment in data quarterly. this will help you to estimate the future growth table wise