Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


No of Dimensions and Facts

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

No of Dimensions and Facts Empty No of Dimensions and Facts

Post  dbadwh Fri Oct 14, 2011 1:04 pm

Is there any ratio on number of dimensions ,facts and fact less facts in a data mart?

dbadwh

Posts : 31
Join date : 2011-09-30

Back to top Go down

No of Dimensions and Facts Empty Re: No of Dimensions and Facts

Post  BoxesAndLines Fri Oct 14, 2011 1:53 pm

One to many. :-)

Kimball has guildelines in his books. I think those run on the low side. I get good performance with 15-20 dimensions.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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