Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between star schema and snow flake schema?
- 1 Answers
- 12 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 |
What are the two types of Match() function?
How many dimensions can be used in bar chart?
List some common ports used by QlikView services?
Give some date and time functions?
What is the use of connect statement?
How can we get the number of statements which have caused errors during a script execution?
Explain the process of script execution in brief?
What is the use of - export sheet layout?
What is inline data? How can we load it into qlikview?
Tell three major disadvantages of using qlikview?
What is central link table?
Optimized and un optimized qvd load situations?
QlikView 
