Hi, Could any one tell me which schema (star and snow flake schema) wi

Advertise your Business Here

Refer this Site

Login | Sign Up


	To Refer this Site to Your Friends Click Here

Categories >> Software >> Data-Warehouse >> Data-Warehouse-General

Data Warehouse General Interview Questions

Question

Hi,

Could any one tell me which schema (star and snow flake 
schema) will take much space?

Thanks
S.A.K

Question Submitted By :: Ashakamuri

I also faced this Question!!

Rank

Answer Posted By

Re: Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K

Answer
# 1

Star flake schema will take more space than snow flake 
schema.
Snow flake schema approach increases the number of joins 
and results poor performance in data retrieval. In few 
organizations, they try to normalize the dimension tables 
to save space.

keke...

Is This Answer Correct ?

0 Yes

0 No

Kranthi.kunta

Re: Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K

Answer
# 2

Hi

 star schema takes more space then the snowflake because 
star schema is denormalised schema and snowflake is 
normalised

Is This Answer Correct ?

0 Yes

0 No

Prasant Tripathy

Question	Asked @	Answers
Other Data Warehouse General Interview Questions


difference between For each and for all		1
What is DTS ?		1
Compare ?Data mining? and ?Data Warehousing??		2
What is IQD file?		1
What is mapplet?		1
what are different types of partitioning in oracle ?		2
three ways sql*loader could load data, what are those three types?		1
What are Fact tables and Dimension Tables?		2
what is the difference between etl tool and olap tools		3
Explain in simple terms, the concept of Data Mining.		2
What is an OLTP (Online Transaction Processing) System?		2
DWH architecture?		3
What is subject area?		1
Tell me one example for junk dimension?	TCS	2
What are cursors?		4
Can you explain how analysis service works?		1
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?	Oracle	3
How many repositories can we create in Informatica?	Informatica	7
What Oracle tools can be used to design and build a W/H?		1
what are the types of dimension tables		6

For more Data Warehouse General Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com