Demystifying the Type 2 Slowly Changing Dimension with BIML



Most data warehouses have at least a couple of Type 2 Slowly Changing Dimensions. We use them to keep history so we can see what an entity looked like at the time an event occurred. From an ETL standpoint, I think Type 2 SCDs are the most commonly over-complicated and under-optimized design pattern I encounter. I show the design pattern and the BIML for a Type 2 dimension to demonstrate that they don't have to be difficult.

published 12.21.15

last updated 12.21.15



  • dimension


You are not authorized to comment. A verification email has been sent to your email address. Please verify your account.


There are no comments yet.