Create data model from any existing SQL

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 […]

Begin typing your search term above and press enter to search. Press ESC to cancel.

Back To Top