Slowly Changing Dimension

Slowly Changing Dimension Implementations: Asynchronous

Finally I think I’m done with the topic of Slowly Changing Dimensions for the moment. This doesn’t mean this is all you need to know about them, or that I’ve covered every angle and consideration (I haven’t), but this should now suffice for most people to make an informed and considered decision as to when …

Slowly Changing Dimension Implementations: AsynchronousRead More »

Slowly Changing Dimension Implementations: Synchronous Triggers

In the previous post I went through what a Slowly Changing Dimension is and why they can be such a problem for people when designing database solutions. Here I’ll start to work through a few implementations. Note there is no real “this is the way to go” solution because each has its advantages and pitfalls …

Slowly Changing Dimension Implementations: Synchronous TriggersRead More »

Scroll to Top