Enterprise Data Warehouse Question:
Explain the main differences between star and snowflake schema?
Answer:
Star 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
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
| Previous Question | Next Question |
| What is a junk dimension? What is the difference between junk dimension and degenerated dimension? | Explain What is the advantages data mining over traditional approaches? |