Now that the Wine Club has decided to build a data warehouse, it must further decide:
Where is it to be placed?
What technology should be used?
How will it be populated?
These are problems experienced by most organizations when they attempt to build a data warehouse. As we have said, the business applications have been designed using technology and methodologies that were appropriate when they were developed. At the time, no consideration was given to decision support. The applications were designed to satisfy the business operational requirements.
The Wine Club must draw its warehouse data from three very different software environments:
Also, these applications reside on two ...