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
Answer: D