What is the difference between snowflake and star schema?
- 1 Answers
- 1144 Views
- I also Faced
- E-Mail Answers
Answer / Rajat Pratap Singh
Snowflake Schema is an extension of Star Schema where the fact table in a star schema is further normalized by breaking down larger dimension tables into smaller, more detailed tables. This results in a more complex structure with multiple levels of hierarchy resembling a snowflake. The main difference lies in the normalization level and the resulting complexity.
| Is This Answer Correct ? | 0 Yes | 0 No |
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,
What is data validation strategies for data mart v?
Explain how to get the first 100 rows from the flat file into the target?
What is data analysis? Where it will be used?
Store (and count) non-fact records?
What is the main difference between inmon and kimball philosophies of data warehousing?
Best institute for MS BI training in Hyderabad, India?
what is an use case?
1 Answers InfoAxon Technologies,
What is factless fact schema?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is cubes?
What is fact less fact table? Where you have used it in your project?
Teradata 
