How many Dimension tables

View previous topic View next topic Go down

How many Dimension tables

Post  premasiuc on Fri Sep 23, 2011 9:58 am

HI
we have 25 different lookup codes and description in one code type table.

should we consider the design of each dimension with each lookup code and description?If so then we end up having 25 dimensions
Or we should join couple of lookup codes into one dimensions like a junk dimensions
then we end up having may be 10 to 15 dimensions.

or should we consider the only one code type table with code type, code and description columns in one table?

Thanks in Advance

premasiuc

Posts : 3
Join date : 2010-02-18

View user profile

Back to top Go down

Re: How many Dimension tables

Post  BoxesAndLines on Fri Sep 23, 2011 12:07 pm

Stuff you filter by, put into a dimension. Stuff you just report on, stick in junk dim.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: How many Dimension tables

Post  premasiuc on Fri Sep 23, 2011 1:25 pm

Thanks for your reply,
so option3 creating only one table with three columns code type , code and description is not a good design correct?


premasiuc

Posts : 3
Join date : 2010-02-18

View user profile

Back to top Go down

Re: How many Dimension tables

Post  hang on Fri Sep 23, 2011 6:37 pm

Correct, option 3 should be avoided. Use junk dimensions, and if necessary, group the codes into a few junk dimension tables, each with reasonable size (say <100,000). You may need to conduct some data profiling by SELECT DISTINCT to fine tune your grouping.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

Re: How many Dimension tables

Post  Sponsored content


Sponsored content


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