Menu

1 / 5

MLV + SCD2: Is SCD2 in Bronze the Right Pattern Before Silver MLVs?

DEV Community: azure·Sai Prudhvi Neelakantam·about 9 hours ago
#nlP5NKcT
#devtoazure#devto#dev#history#change
Reading 0:00
15s threshold

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.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.