SCD type 3

Keep a fixed number of prior values as extra columns on the same row. It answers exactly one question — what did this look like before the last change — without the join complexity of type 2. It is rare in practice because the question it answers is rare, and because it quietly caps history at one step, which nobody remembers until someone asks about the step before.