You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are…

Unchanged Output routes rows where no column values have changed and does not create expired or current row indicator columns.

Inferred Member Updates Output handles rows for inferred members that need updating, not the creation of expired and current row indicator columns.

The Historical Attributes Inserts Output is used when a dimension member has historical attributes that have changed. It causes Derived Column transformations to be added to the data flow that create the necessary columns to mark the old row as expired and identify the new row as current, which is fundamental to Type 2 Slowly Changing Dimension handling in SSIS.

Fixed Attribute Output routes rows where a fixed attribute has illegally changed and triggers an error or redirect, not the generation of expired or current row indicators.

Changing Attributes Updates Output routes rows where a changing attribute has changed and updates those values in place, without creating expired or current row indicator columns.