Fact Dimension issue

  • Hi All,

    requirement :

    "Fact dimension – load from LatencyDays"

    Do I need to create this dim separately or else while creating cube automatically creating a fact dim

    with fact table name.

    Is this same which I mentioned as requirement.

    If yes, taking only one Latency days column into dim is that fine for fat dim, or else do I need to take all key columns into dim.

    Please help in understanding the degenerate dim.

    Thanks,

    NIHARIKA

  • niha.736 (6/12/2013)


    Please help in understanding the degenerate dim.

    We call degenerate dimension a dimension key (sitting on a fact table) that does not have an actual dimension table related. An example of this would be a check number, a fact table like fact_checks would have a check_number column that looks like a dimension but there is no dimension table for it therefore, a degenerate dimension as labeled by Kimball.

    Hope this helps.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • Hi Paul Thanks For the reply,

    If you can provide some more information on this, It will help me to understand better.

    1. will degenerate dimension contain only one attribute ?

    as u mentioned in ur example ( check number attribute)

    2. I have created cube(SSAS 2012), while creating it, it prompts me to create a dimension based on my fact table . can we say this as degenerate dimension which I mentioned as requirement in my above post.

    3. what could be the dimension key for this degenerate dimension ?

    Is that check number attribute or some other fact key?

    Thanks & Regards,

    NIHARIKA

  • niha.736 (6/12/2013)


    Hi Paul Thanks For the reply,

    If you can provide some more information on this, It will help me to understand better.

    1. will degenerate dimension contain only one attribute ?

    as u mentioned in ur example ( check number attribute)

    2. I have created cube(SSAS 2012), while creating it, it prompts me to create a dimension based on my fact table . can we say this as degenerate dimension which I mentioned as requirement in my above post.

    3. what could be the dimension key for this degenerate dimension ?

    Is that check number attribute or some other fact key?

    In short, since a degenerate dimension is NOT a dimension table but just a column on a fact table that has the look and feeling of a dimension - like a check number - then, yes, it has a single attribute... stored on the fact table!

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 4 posts - 1 through 3 (of 3 total)

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