Dealing with a Large Dimension

    General discussion

  • I have a Relation dimension which is {RelationID int, RelationType varchar(50)}. This is a kind of "Super" dimension because it covers many other potential dimensions. For example Customers, Suppliers, PurchaseOrders, SalesOrders, etc. There are currently 50 different dimensions that might be covered by such data. The main fact table associated with it is RelationUpdate {RelationID, RelationType, UserID, Role, Date} - which is counting what object a user updated.

    If you wanted to have a better relationship with real dimensions what would be the best way forward? 

    It suggests expanding the RelationUpdate fact table with many columns, one for each RelationType. Is it possible and reasonable?

    Thursday, January 19, 2012 2:50 AM

All replies

  • Trying to get a better understanding of what your relation dimension is, how does it cover the other dimensions.

    On your RelationUpdate fact table one thing to avoid are the varchar columns. If you already have a RelationID, you should avoid including the RelationType in the fact.

    mustafa hussain
    Wednesday, February 01, 2012 10:35 PM