What is the main difference between star and snowflake star schema? Which one is better and why?
Submitted by: AdministratorIf u have one to may relation ship in the data then only we choose snowflake schema, as per the performance-wise every-one go for the Star schema. Moreover, if the ETL is concerned with reporting means choose for snowflake because this schema provides more browsing capability than the former schema.
Submitted by: Administrator
Submitted by: Administrator
Read Online Data Warehousing Job Interview Questions And Answers
Top Data Warehousing Questions
| ☺ | What is the difference between aggregate table and materialized view? |
| ☺ | "A dimension table is wide but the fact table is deep," Explain the statement in your own words. |
| ☺ | What is the advantages data mining over traditional approaches? |
| ☺ | What are data validation strategies for data mart validation after loading process? |
| ☺ | Can you pass sql queries in filter transformation? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
