noeld (3/19/2007)
A 10GB data warehouse is small enough to follow the proposed procedure.When your data warehouse reaches 200 to 500GB you will get into a TOTALLY different ball game.
Cheers,
When you have 500G you strategy has to be changed. You may check if schema level can be replaced or another set of objects, or some other solutions. It is not as scary as people thinking. We have 80-100G statistical databases but the strategy is different.