GeekInterview.com
Series: Subject: Topic:
Question: 60 of 129

what is rapidly changing dimension?

Asked by: Interview Candidate | Asked on: Jul 27th, 2006
Showing Answers 1 - 4 of 4 Answers
praveen

Answered On : Sep 11th, 2006

There is no Dimension called Rapidly changing dimension in DWH.  But if you consider overall ODS tables; a rapidly changing dimension is one that holds the transactional data rather than staging data.

  
Login to rate this answer.
Kumar Saurabh

Answered On : Sep 17th, 2006

There is a Dimension called Monster Dimension.

I hope if you can treat this as a rapidly changing dimension.

  
Login to rate this answer.
juha_teuvonnen

Answered On : Jul 11th, 2007

View all answers by juha_teuvonnen

A rapidly changing dimension is a result of poor decisions during the requirements analysis and  data modeling stages of the Data Warehousing project. If the data in the dimension table is changing a lot, it is a hint that the design should be revisited.

Yes  1 User has rated as useful.
  
Login to rate this answer.
dipanshu handoo

Answered On : May 26th, 2012

A dimension is considered to be a rapidly changing dimension if one or more of its attributes changes frequently in many rows. For a rapidly changing dimension, the dimension table can grow very large from the application of numerous Type 2 changes.

  
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.