Interested to Buy Any Domain ? << Click Here >> for more details...
When should you use a STAR and when a SNOW-FLAKE schema?
- 6 Answers
- 49582 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / malli
usually star schema is the best option for end users due to
its simple design and navigation.
snow flaking is the process of normalizing the dimension
table.For example the customer dimension table usally will
have millons of rows.The updations will take palce
concerned to demographic information(city,place,..).By
snowflaking, these attribute can be seperated and put in
another dimension table, so the updations would be quite
easier.
| Is This Answer Correct ? | 11 Yes | 14 No |
Post New Answer View All Answers
Can decision tree be implemented using SQL?
What is data warehouse architecture?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
How can we load the time dimension?
What are the steps of implementing data warehousing?
what is parallel query?
Can any one explain the hierarchies level data warehousing.
What are the differences between datamart vs. Reporting cube?
Explain what are the different methods of loading dimension tables?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
In microstrategy, how can we direct the sql generated to use a specifc table?
What are data modeling and data mining? Where it will be used?
What is data cleaning? How can we do that?
How to calculate fact table granularity?
Explain how many ways you create ports?
