Answered Questions

  • what is rapidly changing dimension?

    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.

    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.