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.
No comments:
Post a Comment