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.

Kumar Saurabh

• Sep 17th, 2006

 

There is a Dimension called Monster Dimension.

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

juha_teuvonnen

 Profile Answers by juha_teuvonnen 

• Jul 11th, 2007

 

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.

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.