What should you use?

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

View Answer

Answer: D