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
A.
or
an Execute SQL task that executes a MERGE statement on the database.
Yeah, agreed
In previus dump there is some disscussion that D is correct.
http://www.aiotestking.com/microsoft/you-need-to-add-a-task-or-component-to-the-package-that-allows-you-to-implement-the-scd-logic-6/
agree
D
Firstly, anything Merge can do, script component can do.
Secondly, merge component will create two rows even you map inputs to different output columns. So one extra step needs to be done.
A practical way is in the script component create extra output columns so you will have new value, old value, and change effective date.
So answer is A
Agree. Type-3 requires to update 2 columns: original & new value. If we use Merge, it will create 2 rows, which we will have to do some additional processing to make it into 2 columns.
Using Script component, we can directly add 2 columns that are needed for Type-3.
D is correct