You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing the use of Slowly Changing Dimension Transformation Outputs. One of the output options are…

Unchanged Output routes rows where no differences are detected between the source and destination, meaning no update action is taken.

Inferred Member Updates Output routes rows that match an inferred dimension member (a placeholder record), updating those specific placeholder records rather than standard attribute changes.

Historical Attributes Inserts Output handles SCD Type 2 changes, inserting a new row to preserve historical values rather than updating the existing record.

Fixed Attribute Output routes rows where a fixed attribute - one that should never change - has changed, typically sending them to an error path rather than an update.

Changing Attributes Updates Output handles SCD Type 1 changes, where the changing attribute columns in the existing dimension record are updated in-place (overwritten) with the new values from the source, directly modifying the existing lookup table record.