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?
- 1 Answers
- 1261 Views
- I also Faced
- E-Mail Answers
Answer / Nishant Saxena
The main difference between Snowflake Schema and Star Schema lies in their normalization level. Star Schema has a denormalized design with minimal joins, whereas Snowflake Schema is more normalized and may require multiple joins. Situations where Snowflake Schema might be better than Star Schema include: 1) Reducing data redundancy for large fact tables with fewer foreign keys. 2) Simplifying ETL processes by allowing the separation of closely related dimensions into sub-dimensions. However, the opposite is true when dealing with simpler data structures or when reducing join complexity is a priority.
| Is This Answer Correct ? | 0 Yes | 0 No |
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain what are the different methods of loading dimension tables?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are session timeout and application timeout? Where we have to do this process?
What is called data cleaning?
Explain what are non-additive facts in detail?
What is application.cfm?
What are Non-additive facts?
How to use the tool Ontobulider
Tell me one example for junk dimension?
What is operational data source (ODS)?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
Teradata 
