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...

  1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category

Hi,

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

Thanks
S.A.K

Question Posted / ashakamuri

Answers were Sorted based on User's Feedback



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

Answer / prasant tripathy

Hi

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

Is This Answer Correct ?    10 Yes 0 No

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

Answer / laz

The answer is STAR SCHEMA . As, the data stored in
diamensional tables of the star schema is denormalized
hence it increases the space needed for storage of data.

Is This Answer Correct ?    3 Yes 0 No

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

Answer / kranthi.kunta

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 ?    3 Yes 2 No

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

Answer / pratap gangula

In Star schema the dimensions can have attributes that may have low cardinality which when separated out in other table will decrease the storage space.

Is This Answer Correct ?    1 Yes 0 No

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

Answer / 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

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

Answer / 9885657928

Snow flake schema
why because a denormalized dimentional table splitted into
one or more tables which results in normalization of
dimentions.It hempers the Query performance due to more
number of joins.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Data Warehouse General Interview Questions

I need a good brd and uc template?

0 Answers  

How to provide security in frame work manager for a query subject?

0 Answers  

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

0 Answers  

Can you brief about the Data warehouse project you worked on?

0 Answers   Deloitte, TCS,

Explain what are the vaious etl tools in the market?

0 Answers  

What are target types on the server?

0 Answers  

What are aggregate transformation?

0 Answers  

What is analytical or analytic mean?

0 Answers  

Explain what does level of granularity of a fact table signify?

0 Answers  

What is surrogate key? Explain with examples.

0 Answers  

What is dimension modeling?

0 Answers  

What is mean by aggregate aware?

0 Answers  

For more Data Warehouse General Interview Questions Click Here
Categories