Snir David My name is Snir David.
I'm a proffessional developer delivering great software to production.
I post concise knowledge bits on my account Slowly changing dimensions in depth 07/11/2020

In the lecture, we will dive deep into the concept of slowly changing dimensions and the different types.

  • SCD type 0: Keep original
  • SCD type 1: Override
  • SCD type 2: Add historical row
  • SCD type 3: Add a new column
  • SCD type 4: Mini dimension