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 implem

The correct answer is C. a Merge component. Note: Type of Slowly Changing Dimensions Slowly Changing Dimensions are categorized into three types named: Type 1, Type 2, and Type3. The Type 1 SCD does not maintain the history of changing attributes, it overwrites values of the Type 2 maintains historical values for changing

Extract and transform data

Question

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?

Options

Aa Data Conversion component
Ban Execute SQL task that executes a MERGE statement on the database
Ca Merge component
Dan Expression task

How the community answered

(34 responses)

A
12% (4)
B
6% (2)
C
79% (27)
D
3% (1)

Explanation

Note: Type of Slowly Changing Dimensions Slowly Changing Dimensions are categorized into three types named: Type 1, Type 2, and Type3. The Type 1 SCD does not maintain the history of changing attributes, it overwrites values of the Type 2 maintains historical values for changing attributes. Type 3 that we do not use much maintains separate columns for changed attributes. SSIS SCD wizard supports both Type 1 and Type 2. Using MERGE instead of SCD wizard Replacement of SCD wizard with MERGE is not a straightforward technique. If the SCD has both Type 1 and Type 2 types attributes, they need to be handled separately.

Topics

#SCD Type 3#slowly changing dimension#Merge transformation#data flow

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice