Select Page

TSQL: MERGE With EXCEPT to Handle Type 2 Loading

Type 2 Loading is a pattern that is often used to incrementally load dimensions in a data warehouse. But you can also use it for loading satellites in a data vault or loading tables in a historical/persistent staging area. It consist of three parts: Identify new rows...

Four Approaches to Data Warehousing

The requirements of a Data Warehouse solution continually change during its life time. For some organizations you’ll typically expect more changes than others. Think of maturity, history of organizational changes: mergers, acquisitions etc. You should adopt a solution...