You are building an SSIS ETL data flow to update a dimension table from the corresponding source table in the transactional database. You want to preserve records of updates, deletes or inserts in the dimension table, and create a new row when there are changes of data. Which output of a SCD transformation should you use?

Group of answer choices

Fixed Attribute Output

Changing Attributes Updates Output

Historical Attributes Inserts Output and New Output

Inferred Member Updates Output