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
- 6 Answers
- 11596 Views
- Accenture, IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
Explain Process flow in data warehouse??
Explain what are the different methods of loading dimension tables?
What is the main difference between star and snowflake star schema? Which one is better and why?
How many types of facts and what are they?
What is the use of tabular model, tabular sql, tabular reference in real time application?
which automation tool is used in data warehouse testing?
How to create prompts in report net?
Explain how to generate iqd file from framework manager?
Explain what are the various transformation available?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is the limit to the number of sources and targets you can have in a mapping?
Teradata 
