Which option is the output that causes this?
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 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 causes Derived Column transformations to create columns for the expired row and the current row indicators.
A. Inferred Member Updates Output B. Historical Attributes Inserts Output C. Fixed Attribute Output D. Changing Attributes Updates Output