I used AI tools to help draft and edit this post. I checked the facts and the wording, and the original lives at geekindata.com . The diagrams are on that page.
SCD2 as a product spec
Key takeaways
Dim attribute history is SCD2 before as-of reports ship.
MLVs (or named equivalent) own the SCD transform over the change feed.
Two histories may be separate when upstream readiness differs.
Event-type flags travel with history rows; DAX does not reinvent them.
Gold grain and semantic as-of relationships are documented as one spec.
As-of acceptance includes known change and correction fixtures.
Current-state dimensions lie the moment an attribute changes. Dashboards that say "what is it now" are fine for current-state screens.…