based on what you are asking - in my opinion i would opt to share the
dimension. trying to keep a second copy in sync seems like it would be added
overhead with very little benefit.

time dimension would be a good example of this - no sense in having multiple
time dimensions.

there are some good books out there on this stuff - look for books from
ralph kimball.

hth

Sal



[quoted text, click to view]

If you have two fact tables that share a dimension is it better to duplicate
the dimension by adding a copy of it to the warehouse or should you share
the single dimension between the fact tables?