Slowly Changing Dimension (SCD) Type 6 is also called as “Hybrid SCD” that combines three fundamental SCD techniques. Type 6 can be used when you want to maintain complete history and would also like to have an easy way to manage current version.

The point of “type 6” or “Hybrid” processing is that your track changes by adding a new row for each new version but then you update some of the attributes on previous versions to reflect the current state of data. That way the data can be filtered and rolled-up across all versions for reporting purposes.

SCD Type 6 is a combination of type 1 + type 2 + type 3

Type 1 – The data gets overwritten for all the history records i.e., Past values are not preserved
Type 2 – Creating new rows to capture changes using Flag, Version and Date ranges
Type 3 – Adding attributes to the previous record
Type 6 is built on the type 2 technique by also adding current attributes in the dimension so that fact rows can be filtered or grouped by either the type 2 value or the attribute’s current value.