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?
0
0
SCD transformation support only 0,1,2 types.
To implement 3,4,5,6,7 types you have to build
the logic by yourself.
1
0
SCD has Types 1,2,3!
The right awnser should be D.) Merge
0
0
For Type 3, D) Merge
0
0
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.
1
0