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

How many Dimension tables

3 posters

Go down

How many Dimension tables Empty How many Dimension tables

Post  premasiuc 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

Back to top Go down

How many Dimension tables Empty Re: How many Dimension tables

Post  BoxesAndLines Fri Sep 23, 2011 12:07 pm

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

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

Back to top Go down

How many Dimension tables Empty Re: How many Dimension tables

Post  premasiuc 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

Back to top Go down

How many Dimension tables Empty Re: How many Dimension tables

Post  hang 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

Back to top Go down

How many Dimension tables Empty Re: How many Dimension tables

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