Much Ado About Loading

Recent chatter in the data warehousing industry has again raised the topic of data loading performance. With each new version of a database used for warehousing, the vendor trumpets their performance, trying to one-up their database competitor. There can be no doubt that physical movement of data from file to database is a critical component of the load, but is it really where the bulk of the time is spent on the nightly refresh? This raises the question: what does it mean to load the warehouse? Read more