in our datawarehouse here we have some very wide fact tables. 40 attributes sounds more than agreeable.
we have taken a different tack with the dimensions, for all 6 of your date and time fields there would be a dimension on date and one on time. we do not use synonyms, but aliases in the queries.
of the 2 options, there is maintenance in the first with managing synonyms, and maintenance in the second with hairy queries.
which path do you wish to go down?
good luck :)
Main Topics
Browse All Topics





by: sujith80Posted on 2007-07-10 at 04:50:23ID: 19452548
It is perfectly fine, and a fact with 40 attributes is relatively small.
For the Date and Time dimensions you have listed above: You can have synonyms in the database which points to the same underlying table. It will help you to logically separate the dimensions, and will be easier while reporting.
The idea of re-using the dimensions reduces the number of dimension tables; hence the dimension maintenance becomes easier.