How many Dimension tables

[premasiuc]

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

[BoxesAndLines]

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

[premasiuc]

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

[hang]

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.

[Sponsored content]