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