GeekInterview.com
Series: Subject: Topic:
Question: 42 of 725

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

Asked by: amk742 | Member Since Apr-2011 | Asked on: Apr 20th, 2011

View all questions by amk742

Showing Answers 1 - 5 of 5 Answers

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.
reubenrs

Answered On : Sep 23rd, 2011

View all answers by reubenrs

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.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.