SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Fact Dimension issue


Fact Dimension issue

Author
Message
niha.736
niha.736
SSC Veteran
SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)

Group: General Forum Members
Points: 204 Visits: 233
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
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13747 Visits: 4639
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.
niha.736
niha.736
SSC Veteran
SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)

Group: General Forum Members
Points: 204 Visits: 233
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
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13747 Visits: 4639
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search