Type 6 slowly changing dimension is described as a combination of Type 1, Type 2, and Type 3.

Type 6 slowly changing dimension is described as a combination of Type 1, Type 2, and Type 3.

• A. Type 6 SCD
• B. Type 0 SCD
• C. Type 1 SCD
• D. Type 2 SCD

Answer: (A)

Type 6 SCD blends behaviors from Type 1, Type 2, and Type 3. It overwrites current values for attributes that don’t need full historical tracking (Type 1 behavior), while simultaneously preserving complete history by creating new versioned rows (Type 2 behavior), and it keeps a prior value of some attribute within the same row (Type 3 behavior) for quick reference. This combination lets you see the current state, review the full history, and access a previous value without extra joins. For example, when a customer changes address and status, you update the current row’s address (Type 1), insert a new historical row capturing the change (Type 2), and keep the previous status in an extra column on the current row (Type 3).

Type 6 SCD blends behaviors from Type 1, Type 2, and Type 3. It overwrites current values for attributes that don’t need full historical tracking (Type 1 behavior), while simultaneously preserving complete history by creating new versioned rows (Type 2 behavior), and it keeps a prior value of some attribute within the same row (Type 3 behavior) for quick reference. This combination lets you see the current state, review the full history, and access a previous value without extra joins. For example, when a customer changes address and status, you update the current row’s address (Type 1), insert a new historical row capturing the change (Type 2), and keep the previous status in an extra column on the current row (Type 3).