Explain the difference between star and snowflake schemas.
Answer
A snow flake schema design is usually more complex than a start schema.
In a start schema a fact table is surrounded by multiple fact tables. This is
also how the Snow flake schema is designed. However, in a snow flake schema,
the dimension tables can be further broken down to sub dimensions. Hence, data
in a snow flake schema is more stable and standard as compared to a Start
schema.
E.g. Star Schema: Performance report is a fact table. Its dimension tables
include performance_report_employee, performance_report_manager
Snow Flake Schema: the dimension tables can be broken to
performance_report_employee_weekly, monthly etc.
More Related Links
Answer -
A data warehouse can be considered as a storage area where interest specific or
relevant data........
Answer - As mentioned, data in a warehouse comes from the
transactions. Fact table in a data warehouse consists........
Answer - ETL is Extract Transform Load. It is a process of
fetching.........
Answer -
Data warehousing is merely extracting data from different sources, cleaning
the........
|