Data Warehouse

Data Warehouse Fact Constellation Schema and Design

Basically, Data warehouse fact constellation schema is viewed as a collection of many star schemas. For each star schema or snowflake schema it is possible to create Fact Constellation schema. This schema is one of the widely used data warehouse design methodology and is also called Galaxy schema. Sophisticated application required the Fact constellation schemas. Read: Star Schema model in Data Warehouse Snowflake Schem Model in Data Warehouse Step by Step Guide to Dimensional Data Modeling Slowly Changing Dimensions (SCD) in Data Warehouse Rapidly Changing Dimension in Data Warehouse Representation…

Continue ReadingData Warehouse Fact Constellation Schema and Design
Comments Off on Data Warehouse Fact Constellation Schema and Design
December 3, 2016
Data Warehouse

Data Warehouse Snowflake Schema Model and Design

Data warehouse Snowflake schema is extension of star schema data warehouse design methodology, a centralized fact table references to number of dimension tables, however, one or more dimension tables are normalized i.e. dimension tables are connected with other dimension tables. Primary Keys from the dimensions flows into fact table as foreign key. Star Schema model in Data Warehouse Data Warehouse Fact Constellation Schema and Design Snowflake schema increases the level of normalization in data, the dimension table is normalized into multiple tables. This schema has a disadvantage in terms of data retrieval, we…

Continue ReadingData Warehouse Snowflake Schema Model and Design
Comments Off on Data Warehouse Snowflake Schema Model and Design
August 3, 2016