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

  Discussion forum


Leave an answer