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
Isn’t it supposed to be B?
SCD transformation support only 0,1,2 types.
To implement 3,4,5,6,7 types you have to build
the logic by yourself.
SCD has Types 1,2,3!
The right awnser should be D.) Merge
For Type 3, D) Merge
How it can be D? Type 3 can be implemented by T-SQL MERGE Statement, so it should be Option A.
Merge Component is used to join two ordered data sets.