What is the difference between star and snowflake schemas?
- 1 Answers
- 1371 Views
- I also Faced
- E-Mail Answers
Answer / Hina Jain
The main difference between a Star Schema and a Snowflake 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 |
Is there any default username & pwd for bo designer & supervisor?
What is difference between Mapplet and reusable transformation?
what is data validation strategies for data mart validation after loading process
What are the different models used in cluster analysis?
How Materialized Views are linked with Oracle DataWare house?
how do you use commit frequencies? how does it affect loading performance?
How can we import and export using BCP utility?
Explain swot analysis?
What are snapshots? What are materialized views & where do we use them?
Explain the difference between keylokup and joiner?
What is prompt types of prompts?use of prompts syntax of prompt?
what are different ways of loading data to data warehouse using oracle?
Teradata 
