Different Ways Of Generating Data For Date Dimension Table

Dimension Table

Time is the most precious thing in the world. In business domain, time is money and everything. When we are doing data warehouse, we need date dimension or using it to track business trends, analyze data and figure out changes in the business pattern over the time.  There Continue reading...

Star Schema vs Snowflake Schema vs Fact Constellation Schema

Star Schema

The Star Schema is the simplest data warehouse scheme. When we data warehousing with the star schema, database diagram resembles a star design. That is why this schema called as star schema. One fact table surrounded by dimension tables and if all the dimension tables are parent table then it's star schema data warehouse model. In this schema, Continue reading...