Post reply

Data warehouse fact or dimension

  • November 18, 2015 at 4:54 am

    #302314

    Hi

    I understand the concept of a slowly changing dimension.

    What if I have a quickly changing dimension

    The developer working on a project changes every day or two say.

    Should this be built in a fact table? Or should it be built in a dimension table the same principles as a slowly changing dimension?

    Thansk

  • November 18, 2015 at 5:52 am

    #1840616

    Hi

    SCD type 2 is works well if the table is not too large and the changes doesn't happen frequently. But when the lot of changes happen in the attributes of the dimension table, it starts growing causing considerable performance problems.

    You could consider other methods to handle it, such as mini dimension structure or junk dimension.

    Br,

    Mike

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply