Multiple choice technology

Which is the slowly changing dimension method that you can't us in a data flow task in SSIS?

  1. Type 1 dimensions

  2. Type 2 dimensions

  3. Type 3 dimensions

  4. Inferred dimensions
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The SSIS Slowly Changing Dimension wizard natively supports Type 1 (overwrite) and Type 2 (add historical rows). Type 3 dimensions require custom implementation using OLE DB Command or script components because they're not directly supported.

AI explanation

The SSIS Slowly Changing Dimension wizard/data flow transformation only supports Type 1 (overwrite), Type 2 (historical tracking with new rows), and inferred member handling — it has no built-in support for Type 3 (tracking limited history in extra columns), which must be implemented manually if needed.

Keep practicing — related questions