Question: what are the different scd types?
Answer: Type 0 – Fixed Dimension. No changes allowed, dimension never changes.
Type 1 – No History. Update record directly, there is no record of historical values, only current state.
Type 2 – Row Versioning. ... 
Type 3 – Previous Value column. ... 
Type 4 – History Table. ... 
Type 6 – Hybrid SCD.