What is SCD Type 3 and Where do you use it in implementation ?

Questions by amk742

Showing Answers 1 - 5 of 5 Answers

reubenrs

  • Sep 23rd, 2011
 

If the requirement is to maintain current and previous address of a customer in the target, type 3 can be used.

  Was this answer useful?  Yes

Padmaja Vuppu

  • Sep 27th, 2011
 

When the value of the dimension has to update (by the current value), the old value column of the table has to update by the most previous value of the dimension. Thus we have the CURRENT value and the MOST PREVIOUS value of the dimension. In this case we can use SCD Type 3

  Was this answer useful?  Yes

sriram

  • Sep 27th, 2011
 

scd type3 is used for loading the current & most previous data into target

  Was this answer useful?  Yes

sriinivas kasiboina

  • Feb 15th, 2012
 

SCD Type 3 is used when it is necessary for datawarehouse to keep track of historical changes and when such changes will only for finite number of times.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions