Chinh (lelouvincx) / Slowly Changing Dimension

Created Mon, 25 May 2026 00:00:00 +0000 Modified Mon, 25 May 2026 06:02:25 +0000
75 Words
page
  • https://gemini.google.com/app/dabc4a0a978845c1

  • Keynotes

    • Slowly Changing Dimensions (SCD) refer to how you store historical changes in data
    • Type 0: retain original
    • Type 1: overwrite data
    • Type 2: add new row for historical record
    • Type 3: add new column stand for previous value and current value
    • Type 4: keep the main dimension table for current data, while moving all historical changes to a separate history table
    • Type 6 (1+2+3=6): create new row but also overwrite current state column