GeekInterview.com
Series: Subject: Topic:
Question: 119 of 211

What do you mean by slow dimensions?

Asked by: Hamid | Member Since Feb-2007 | Asked on: Mar 7th, 2007

View all questions by Hamid   View all answers by Hamid

Showing Answers 1 - 2 of 2 Answers
rkiranbedi

Answered On : Mar 27th, 2007



Slowly changing dimension means these dimensions will change according to time,
Ex: In Bank- a/c number, A/c name , address is there then if v change address then address will be a slowly changing dimension for that,
It is of 3 types
Type-I
Type-II
Type-III.

  
Login to rate this answer.
thakkalapellyanil

Answered On : Aug 30th, 2007

SCD means it explainsexactly how the changed data has been loaded into the target database.
There are three types of SCD
SCD1
SCD2
SCD3

SCD1: It holds only current data.
SCD2: It holds the current+historical data.for every datachange it inserts a new record.
SCD3: It holds the current and immediate previous data.

  
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.