Basically, scd type 3 maintains the current and the previous changed data or history.. i don't think so they use in real time projects never heard
Login to rate this answer.
If the requirement is to maintain current and previous address of a customer in the target, type 3 can be used.
Login to rate this answer.
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
Login to rate this answer.
sriram
Answered On : Sep 27th, 2011
scd type3 is used for loading the current & most previous data into target
Login to rate this answer.
sriinivas kasiboina
Answered On : 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.
Login to rate this answer.