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

Too many dimensions per fact?

4 posters

Go down

Too many dimensions per fact? Empty Too many dimensions per fact?

Post  chade25 Tue Feb 19, 2013 1:45 pm

Is it possible to have too many dimensions per fact table? Right now I have 19 dimensions on one fact table, and I could add more.

chade25

Posts : 29
Join date : 2012-04-12
Age : 42
Location : Oregon

Back to top Go down

Too many dimensions per fact? Empty RE: Too many dimensions per fact?

Post  hkandpal Tue Feb 19, 2013 2:26 pm

Hi,

you can have as many as you can , but after 20 it is better you see if you can combine some dimension into a Junk dimn.

thanks

HImanshu

hkandpal

Posts : 113
Join date : 2010-08-16

Back to top Go down

Too many dimensions per fact? Empty Re: Too many dimensions per fact?

Post  BoxesAndLines Tue Feb 19, 2013 10:46 pm

It starts to increase the load times due to all the indexing normally required for FK indexes. That said, I've blown by 20 many times. :-)
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Too many dimensions per fact? Empty Re: Too many dimensions per fact?

Post  Mike Honey Wed Feb 20, 2013 1:16 am

Each new dimension decreases the flexibility of your model - it is much easier to add or change attributes in an existing dimension than add a new dimension. So I tend to lean in that direction e.g. a single Customers dim with many attributes rather than Customer Type dim, Customer Location dim, etc.

Another consideration is the increasing complexity of the end user experience: whether coding star joins or using an OLAP tool you may be making life harder for your testers, report authors and users.

Balanced against that, it can be confusing when junk dimension attributes have absolutely no association with each other.
Mike Honey
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

http://www.mangasolutions.com

Back to top Go down

Too many dimensions per fact? Empty Re: Too many dimensions per fact?

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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