You are designing a data warehouse that contains a customer dimension.
The customer dimension contains the original customer attributes as well as the most recent
set of updated attributes. When a customer is updated, the original customer attributes must
be preserved.
The customer dimension design must:
Support a Type 3 Slowly Changing Dimension (SCD) process
Minimize the total storage consumed
You need to design a solution that meets these requirements.
What should you do?
A.
Design two tables. One table will hold the original customer surrogate key and attributes.
The other table will hold the most recent customer surrogate key and attributes.
B.
Design a table as a Type 2 SCD dimension that holds the surrogate key for each
customer and its attributes. Limit the number of records per customer within the table to two.
C.
Design a table to hold the surrogate key for each customer and its attributes. Add a
column to store an indicator that identifies the record as original data or recent data.
D.
Design a table to hold the surrogate key for each customer and its attributes as well as
additional columns to store the original attributes.
It’s the same question like number 190. The answer for it is C. I think the answer for this question is C too.
Hi,if you notice the answer,you will find Answer D is same as 190 C
Yeah, Kelvin is right. Ans. is D here.
For me D is correct.
Note: SCD Type 3, keeps separate columns for both the old and new attribute values—sometimes called “alternate realities.”
http://blogs.msdn.com/b/karang/archive/2010/09/29/slowly-changing-dimension-using-ssis.aspx
It is “C”