How many measures in a fact table is acceptable?

View previous topic View next topic Go down

How many measures in a fact table is acceptable?

Post  sachinsaxena on Wed May 05, 2010 12:15 pm

Hi,

I would like to find out what is the maximum number of measures allowed in a fact table?

Thanks

sachinsaxena

Posts : 1
Join date : 2010-05-05

View user profile

Back to top Go down

Re: How many measures in a fact table is acceptable?

Post  ngalemmo on Wed May 05, 2010 4:25 pm

No more than their needs to be.

I'm not trying to be cute, but the thing is there is no such thing. The contents should be driven by business requirements and the grain of the fact. Normally you don't store measures that are simple calculations of other measures, but other than that, there isn't any 'maximum'.

If your question has more to do with physical limitations of a particular database system, then I would suggest that if you have a table design that is running up against limits like that, you may want to rethink your design.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum