SCD Type 2: the history the business didn't know it needed
A sales director asks how many customers were in the North region last June. The DWH can't answer because every update overwrites previous data. How I implemented an SCD Type 2 with surrogate keys and validity dates to give the business back its historical memory.
·13 mins