How to create a date dimension in a Data Warehouse
Learn how to create a date dimension (calendar table) in a Data Warehouse with SQL: table, load script and best practic…
4 min
04 Jul 2026
Data Warehouse
Learn how to create a date dimension (calendar table) in a Data Warehouse with SQL: table, load script and best practic…
Data Warehouse
Learn how to implement an SCD Type 2 dimension in a Data Warehouse with simple SQL and keep the full history of changes…
Data Warehouse
Learn to model a data warehouse with a star schema: fact table, dimensions and surrogate keys, with SQL examples.