What is the single most important objective in building a data warehouse?
Ans. Most difficult task in initially creating, and maintaining, a data warehouse is ensuring the validity of the information stored within the database itself. The collecting and cleansing of data from many systems is not an easy task, and a data warehouse project usually fails because the data cannot be validated.