scd2
sqllocks_spindle.engine.strategies.scd2
¶
SCD Type 2 strategy — generate slowly changing dimension versioning columns.
Generates coordinated values for effective_date, end_date, is_current, and version columns that together form a valid SCD Type 2 pattern grouped by a business key column.
Example config
"effective_date": { "generator": { "strategy": "scd2", "role": "effective_date", "business_key": "customer_id", "avg_versions": 3, "min_gap_days": 1 } }