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.