How many Dimension tables
3 posters
Page 1 of 1
How many Dimension tables
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
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
Re: How many Dimension tables
Stuff you filter by, put into a dimension. Stuff you just report on, stick in junk dim.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: How many Dimension tables
Thanks for your reply,
so option3 creating only one table with three columns code type , code and description is not a good design correct?
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
Re: How many Dimension tables
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
Similar topics
» Storing Date Keys in dimension tables versus fact tables
» Number of Columns in Fact Tables vs. Dimension Tables
» Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
» Dimension Design with intermediate tables between fact and dimension
» Question about using date dimension keys in other dimension tables
» Number of Columns in Fact Tables vs. Dimension Tables
» Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
» Dimension Design with intermediate tables between fact and dimension
» Question about using date dimension keys in other dimension tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum