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 data warehouse. When you are new to any project, understanding the existing data model can […]
star schema and snowflake schema in data warehouse
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 or more FACT Tables surrounded by multiple dimension tables. The fact table source keys from […]