how many dimensions is too many
3 posters
Page 1 of 1
how many dimensions is too many
If I have a fact table with too many dimensions --- over 30, does that mean I've created dimensions when they could have been attributes to another dimension table or possibly that I am trying to capture too many business processes within one fact table.
the problem I am having is at this point i havent been given anything but a list of column names that will be provided from an external vendor (this is our source) and I am trying to do a first pass by mapping the column names to a dimension and a fact. My one fact is a detail/transactional fact table for an origination loan. I am thinking about breaking the detail table into various tables (loan detail, loan foreclosure, Equity Loan). I am also thinking about removing some dimensions that I have identified for code attributes and make them part of the loan dimension. Some of the code dimensions i have design actually hold 1 or 2 values. My thought process was that if they wanted to ever use them in a drop down it would be better to have them as their own dimension rather an attribute to the loan dimension.
Any thoughts?
thanks.
the problem I am having is at this point i havent been given anything but a list of column names that will be provided from an external vendor (this is our source) and I am trying to do a first pass by mapping the column names to a dimension and a fact. My one fact is a detail/transactional fact table for an origination loan. I am thinking about breaking the detail table into various tables (loan detail, loan foreclosure, Equity Loan). I am also thinking about removing some dimensions that I have identified for code attributes and make them part of the loan dimension. Some of the code dimensions i have design actually hold 1 or 2 values. My thought process was that if they wanted to ever use them in a drop down it would be better to have them as their own dimension rather an attribute to the loan dimension.
Any thoughts?
thanks.
lconsalvo- Posts : 4
Join date : 2010-08-04
Re: how many dimensions is too many
If you have separate dimensions for various code/value pairs that make more sense to be on another dimension then, yes, you have far too many dimensions.
Don't make these dimensions simply because you want to provide drop down lists. If you need little tables to provide efficient drop-down list, have a bunch of little tables to do that, but don't make them part of the star schema the end user queries. Put the same code value pairs in the appropriate dimension where they belong.
Don't make these dimensions simply because you want to provide drop down lists. If you need little tables to provide efficient drop-down list, have a bunch of little tables to do that, but don't make them part of the star schema the end user queries. Put the same code value pairs in the appropriate dimension where they belong.
Re: how many dimensions is too many
Avoid building a loan dimension if at all possible. The dimension will be 1-1 with your fact table. I'm confused on what you are trying to build. If you are building a loan origination data mart, what would you populate with loan foreclosure and equity loan?
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Schema Roadblock: Dimension vs Fact [Dimensions w/FKs to other Dimensions?]
» Question about Dimensions with SKeys to join with other dimensions.
» Correlated - Separate Dimensions OR Single Dimensions ?
» Deleting Dimensions and Bridge Dimensions
» Design all dimensions as conformed dimensions
» Question about Dimensions with SKeys to join with other dimensions.
» Correlated - Separate Dimensions OR Single Dimensions ?
» Deleting Dimensions and Bridge Dimensions
» Design all dimensions as conformed dimensions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|