The Semantics of Differing SCD2 Techniques
How small differences can have a big impact
Published in
7 min readNov 16, 2023
Recently, I’ve been thinking a lot about dimensional modeling, specifically how we represent different kinds of history in the warehouse / lakehouse. There are many articles that describe how to build an SCD2 table across many languages and platforms. Instead, I want to focus on something more nuanced and less commonly…