Category: Data Warehouse

In this post, I have explained what are Slowly Changing Dimensions (SCD) and how you can implement it in your projects in the efficient manner. What is Slowly Changing Dimension ? A Dimension table stores attributes and descriptive details about […]

In this post I will share a quick method which you can use to create a data model from any existing SQLs in your data warehouse environment. Data Model actually plays a very vital role in building understanding of your […]

In this post I have shared the key differences between star schema and snowflake schema. Star schema is the most commonly used approach to design & develop data warehouse. It is simple to implement in which we have centralised one […]