What are the difference between snow flake and star schema?
- 1 Answers
- 1091 Views
- I also Faced
- E-Mail Answers
Answer / Kalpana Bharti
The main difference between a Snowflake Schema and a Star Schema lies in their normalization level. A Star Schema is less normalized, with fact tables at the center connected to dimension tables through foreign keys. Each dimension table contains all possible values for its attributes. On the other hand, a Snowflake Schema is more normalized, where dimension tables are further sub-divided into smaller tables, reducing data redundancy.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the stages of datawarehousing?
if source contain 10records how you identify header and footer
What is hash partition?
What are the data types present in bo?
Explain me what are conformed dimensions?
What is source qualifier?
Why fact table is in a normal form?
What is aggregate fact table?
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 are the different ways to represent the loading of dimension tables?
What is the advantages data mining over traditional approaches?
Explain vldb?
Teradata 
