Oracle Warehouse Builder 11gR2: Getting Started 2011

Chapter 2. Defining and Importing Source Data Structures

The Warehouse Builder software and Oracle database have been installed, and we're ready to begin building our data warehouse. The first thing we have to do is define what our sources of data will be. If we are going to build a useful data warehouse, we have to know what kinds of information our users are going to need out of the warehouse. To know that, we have to know the following:

• The format in which the data is currently stored and where it is stored.
• Whether there is a transactional database currently in use or not, which supports day-to-day operations and from which we'll be pulling the data.

  A transactional database is different from a data warehouse database in that it is designed to ...