Skip to content
Vol. I · No. 251
Mon · 8 Jun
A Daily Lexicon of Trustworthy Data
The Lexicon

005·14

scd type 2

/ˌɛs.siːˈdiː taɪp tuː/ - n.

1 [colloq.] The full audit trail of every value the business changed its mind about, kept forever, consulted never.Keep. Punchy.This is the problem.

Working definition

2. A slowly-changing-dimension method that preserves history by inserting a new versioned row on each change, with effective-date and current-flag columns.

Filed
See also
  • dimension tableWhere the company keeps every adjective it has ever applied to a customer, none of them governed.
  • schema evolutionThe fossil record of the data model: every layer a column someone added and no one was ever allowed to remove.
  • slowly changing dimensionAn attribute the business called permanent in the requirements meeting and changed twice before launch.