There is a great deal of confusion over the meaning of data warehousing. Simply defined, a data warehouse is a place for data, whereas data warehousing describes the process of defining, populating, and using a data warehouse. Creating, populating, and querying a data warehouse typically carries an extremely high price tag, but the return on investment can be substantial. Over 95% of the Fortune 1000 have a data warehouse initiative underway in some form.
what is data
a data warehouse, and what you do with it. It is the process of creating, populating, and then querying a data warehouse and can involve a number of discrete technologies such as: Source System Identification: In order to build the data warehouse, the appropriate data must be located. Typically, this will involve both the current OLTP (On-Line Transaction Processing) system where the day-to-day information about the business resides, and historical data for prior periods, which may be contained in some