Slowly Changing Dimension (SCD) Type 2

Historical change tracking where analysts can query state over time, including what was the customer segment assignment at quarter end.