hongchen91 (3/11/2008)
Anybody has the experiece implementing, say 3 to 5 fact tables with a dozen dimention tables and the total size of the db is in 100 GB range?How long will a historical load take?
This is highly dependent on the environment & configuration, however in my experience, 3 hours would be the absolute minimum, and I have certainly had to wiat over 2 weeks for some to complete.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]