You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing
Dimension (SCD). You need to add a task or component to the package that allows you to implement the SCD
logic. What should you use?
A.
a Script component
B.
an SCD component
C.
an Aggregate component
D.
a Merge component