What is rapidly changing dimension?

Showing Answers 1 - 3 of 3 Answers

praveen

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

  Was this answer useful?  Yes

Kumar Saurabh

  • Sep 17th, 2006
 

There is a Dimension called Monster Dimension.

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

  Was this answer useful?  Yes

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.

dipanshu handoo

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

  Was this answer useful?  Yes

EssamGad

  • Apr 16th, 2016
 

No, Actually there is something called Rapidly Changing Dim or Fast Growing Dim, it is the Dim that contains an attribute that changes frequently. and one solution is to move this attribute to a new mini dim with a separate foreign key in the fact table.

  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