Explain the main differences between star and snowflake schema?
Submitted by: AdministratorStar schema: A single fact table with N number of DimensionSnowflake schema: Any dimensions with extended dimensions are known as snowflake schema.
star schema: in this we have the centrally located fact tables surrounded by the number of dimensional tables where as in snow flake schema a denormalized dimensional table is subdivided into child dimensional tables
Submitted by: Administrator
star schema: in this we have the centrally located fact tables surrounded by the number of dimensional tables where as in snow flake schema a denormalized dimensional table is subdivided into child dimensional tables
Submitted by: Administrator
Read Online Enterprise Data Warehouse Job Interview Questions And Answers
Top Enterprise Data Warehouse Questions
| ☺ | Explain What is the advantages data mining over traditional approaches? |
| ☺ | What are the main steps to build the data warehouse? |
| ☺ | Explain the different types of data warehousing? |
| ☺ | Explain the main differences between star and snowflake schema? |
| ☺ | Explain the main difference between Inmon and Kimball philosophies of data warehousing? |
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. |
