Fair enough. Which levels of Slowly Changing Dimensions do you use?

I typically use SCD Types 1, 2, and 3. Type 1 overwrites the old value, which is suitable for correcting errors or when history is not required. Type 2 adds a new row with a surrogate key and effective dates, preserving full history; it’s used for attributes that change over time, like address or job title. Type 3 stores the previous value in a separate column, useful for tracking the last change without full history, such as a previous department. I avoid Types 4 and 5 because they require separate history tables or complex partitioning, which add maintenance overhead. By selecting the appropriate SCD type based on business needs, I balance query performance, storage cost, and auditability.