Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Hi,

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

Thanks
S.A.K

Answer Posted / merohin27@gmail.com

star schema consists huge space then the snowflake because 
star schema is de-normalised schema and snowflake is 
normalised thus Star schema consists huge space

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1015


How to pivot data using informatica when you have variable amount of pivot rows?

859


What is the difference between metadata and data dictionary?

1061


explain about dirty dimension?

1072


Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

916


How we are using this function?

1044


What is data analysis?

898


What is the difference between data warehouse and operational systems?

1076


what are the major three types of modeling used?

1019


Explain the main differences between star and snowflake schema?

921


Who needs data warehousing?

1002


Where the cache files stored?

954


What is MODEL is Data mining world?

2535


What are the data marts?

917


How to limit the max no of rows retrieved in the report?

935