Basics - For 80GB Datawarehouse How many records are there in Fact Table There are 25 Dimension and 12 Fac

Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 75 of 111

Print

For 80GB Datawarehouse
How many records are there in Fact Table
There are 25 Dimension and 12 Fact Tables

Total Answers and Comments: 6

Last Update: August 14, 2007 Asked by: srinu

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 22, 2006 05:41:42

#1

Sahadevan

RE: For 80GB Datawarehouse How many records are...

HiIs it enterprises data warehouse ?

Is this answer useful? Yes | No

September 22, 2006 05:51:52

#2

Sahadevan

RE: For 80GB Datawarehouse How many records are...

Hi

Please let me know which data type used .

sahadevan

Is this answer useful? Yes | No

November 25, 2006 04:34:41

#3

hari

For 80GB Datawarehouse How many records are...

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.

Is this answer useful? Yes | No

December 16, 2006 21:33:00

#4

chandra nayak

RE: For 80GB Datawarehouse How many records are...

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?

Is this answer useful? Yes | No

January 22, 2007 21:08:04

#5

RE: For 80GB Datawarehouse How many records are...

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

Is this answer useful? Yes | No

August 14, 2007 01:58:14

#6

Are Ramakrishna Rao

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

Is this answer useful? Yes | No

Sponsored Links

Related Categories

—

Data Warehousing Basics Related

—

Sponsored Links

About Us | Privacy Policy | Terms and Conditions | Contact | Site Map | Add Question | Propose Category | RSS Feeds | Articles Sitemap | Site Updates | Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved