jargon

Data engineering·Modelling for analysis

you overwrite the old value, and last year's report now shows the customer as having always been in Bristol.

SCD type 1

Also calledoverwrite, type 1

Update the attribute in place and keep no history. It is the cheapest and it is right whenever the change is a correction rather than an event — a misspelled name, a fixed category. It is wrong whenever someone will re-run an old report and expect it to match what they printed, which is why it silently rewrites history and why nobody notices until an audit.

Commonly confused with