Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Should my dimension table be this big? Expand / Collapse
Author
Message
Posted Tuesday, August 12, 2014 6:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 10:10 AM
Points: 79, Visits: 463
Ive been reading a bit further into my kmibal book. in this scenario could the color and size be considered as degenerate dimension ie. not bother have them in the product dimension or in there own dimension but jst load them as degenerates into the fact table?

if so what advantage would this give other than avoiding building and maintaining them as separate dimension?

many thanks.
Post #1602260
Posted Tuesday, August 12, 2014 7:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 13,562, Visits: 11,372
ps_vbdev (8/12/2014)
Ive been reading a bit further into my kmibal book. in this scenario could the color and size be considered as degenerate dimension ie. not bother have them in the product dimension or in there own dimension but jst load them as degenerates into the fact table?

if so what advantage would this give other than avoiding building and maintaining them as separate dimension?

many thanks.


A degenerate dimension is usually something that does not really belong into a dimension (such as an OrderID or a ticket number) and chances are small it is ever going to be used in an analysis. However, color and size are going to be used in your analyses, so they should be included in some sort of dimension.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1602265
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse