A good data warehouse model is a hybrid representing the diversity of different components and processes required to acquire, store, package and deliver data.
The expectations from a data warehouse implementation are growing at an exponential rate without compromising the ever-increasing data volumes and shrinking latency. If we think about it, we really should not be surprised at all! Organizations today demand a high degree of access to accurate and timely information so that decision making is fast and effective. At the same time, volume of data is growing exponentially every single day. In addition to this, increasing number of source systems, different data formats and system complexities are directly impacting the system resources and the ROI of the data warehouse.