New posts in Data Warehouse

Fact table foreign keys null?

What are some ways to implement a many-to-many relationship in a data warehouse?

Extrapolate daily historical values from a table that only records when a value changes (Postgresql 9.3)

Apache Spark + Delta Lake concepts

SQL Replace All Tables with Clustered Columnstore Index

How to test(unit test) on ETL process?

Subtract two dates in Microsoft SQL Server

How to calculate Azure SQL Data Warehouse DWU?

What is a staging table?

Why primary key is (not) required on fact table in dimensional modelling?