Bus Schema Vs Str Schema Vs Snow Flake Schema
Bus, Star, Snow flake Schemas in Data Warehousing
BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts.
Star schema is a type of organizing the tables such that we can retrieve the result from the database quickly in the warehouse environment.
Snowflake Schema, each dimension has a primary dimension table, to which one or more additional dimensions can join. The primary dimension table is the only table that can join to the fact table.
BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts.
Star schema is a type of organizing the tables such that we can retrieve the result from the database quickly in the warehouse environment.
Snowflake Schema, each dimension has a primary dimension table, to which one or more additional dimensions can join. The primary dimension table is the only table that can join to the fact table.
No comments:
Post a Comment