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 Star Schema Model and Design

Data warehouse Star schema is a popular data warehouse design and dimensional model, which divides business data into fact and dimensions. In this model, centralized fact table references many dimension tables and primary keys from dimension table flows into fact table as a foreign key. This entity-relationship diagram looks star, hence the name star schema. This model divides the business data into fact which holds the measurable data, and dimension that holds descriptive attributes related to the fact data. For examples, fact data includes price, quantity, weight measurements and related dimension attributes example includes product color, sales…

Continue ReadingData Warehouse Star Schema Model and Design
Comments Off on Data Warehouse Star Schema Model and Design
July 30, 2016