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
Why not a SCD component (task)?
0
0
http://technet.microsoft.com/en-us/library/ms141715.aspx
The Slowly Changing Dimension transformation does not support Type 3 changes, which require changes to the dimension table. By identifying columns with the fixed attribute update type, you can capture the data values that are candidates for Type 3 changes.
0
0
How does a merge component solve this problem?
0
0
I can understand a t-sql merge but not a merge task I guess.
0
0
same here, it would make sense to have an answer make a t-sql merge query, but the merge component is pretty much just an UNION. I hope this doesn’t get really asked in the exam.
0
0
I would reply “A.) Script component” because in a script component you can implement SCD type 3 manually.
If option D.) was “T-SQL merge” I would definitely choose that one. But not a merge component in SSIS.
0
0
How about
an Execute SQL task that executes a MERGE statement on the database
0
0
The facts talked about inside the report are a number of the best out there.
0
0
check beneath, are some completely unrelated internet sites to ours, even so, they’re most trustworthy sources that we use
0
0
please take a look at the web pages we comply with, like this 1, because it represents our picks from the web
0
0
although websites we backlink to below are considerably not associated to ours, we really feel they may be essentially really worth a go by means of, so possess a look
0
0
we came across a cool web page that you just could possibly get pleasure from. Take a appear should you want
0
0
check below, are some totally unrelated web-sites to ours, nonetheless, they’re most trustworthy sources that we use
0
0