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
Above answer was rated as good by the following members: mri_sonam
RE: For 80GB Datawarehouse How many records are...
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
1 
0