Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between star schema and snow flake schema?
- 1 Answers
- 3 Views
- I also Faced
- E-Mail Answers
Answer / Raja Sirohi
The main difference between a star schema and a snowflake schema lies in the normalization of data. Both are optimized for different types of queries:nn- Star Schema: Uses denormalization, where fact tables are joined to dimension tables through foreign keys. This design provides fast query performance for aggregation queries but can lead to redundancy.n- Snowflake Schema: Normalizes the data further by separating the dimensional tables into multiple hierarchical layers. This design reduces redundancy but may negatively impact query performance for aggregation queries.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain QlikView IntervalMatch() and Match() functions?
What is the difference between odbc, ole db & jdbc?
What is set analysis in qlikview?
Tell about the operations that can be performed using the tools given in the menu bar?
What are circular loops in qlikview?
What is a synthetic key?
What are the flavours or editions of qlikview?
what kind of chart we use in qlikview admin?
What is a binary statement in qlikview?
What is the role of QlikView Web Server in QlikView’s architecture?
What is webview mode?
What can you use as an alternative to join?
QlikView 
