Snowflake Schema and Star Schema
<b>Snowflake Schema</b>This provides flexibility and and normalization, which can accommodate complex and dynamic dimension and hierarchies. this schema is also the type of multidimensional model which is used for data warehouse. In this schema, the fact table, dimension table as well as sub dimension tables are contained. this schema form a snowflake with fact tabl...
- 0 Comments
- 50 Views
- Share:
- 0
- 0
Posted By std613
3 months agofacts and dimension tables
facts and dimensional tables are key component in a data warehouse. A fact table consist of records that combine attributes from different dimension tables. These records allows users to analyze different aspects of their business, which can aid in decision-making and improving the business.Dimension tables provide the context and background information for the measure...
- 0 Comments
- 47 Views
- Share:
- 0
- 0