Oracle Warehouse Builder 11g: Getting Started

By Bob Griesemer

 

Oracle Warehouse Builder 11g
Getting Started

 

Competing in today's world requires a greater emphasis on strategy, long-range planning, and decision making, and this is why businesses are building data warehouses. Data warehouses are becoming more and more common as businesses have realized the need to mine the information that is stored in electronic form. Data warehouses provide valuable insight into the operation of a business and how best to improve it. Organizations need to monitor these processes, define policy, and at a more strategic level, define the visions and goals that will move the company forward in the future. If you are new to data warehousing in general, and to Extract, Transform, and Load (ETL) in particular, and need a way to get started, the Oracle Warehouse Builder is a great application to use to build your warehouse. The Oracle Warehouse Builder (OWB) is a tool provided by Oracle that can be used at every stage of the implementation of a data warehouse right from the initial design and creation of the table structure to ETL and data-quality auditing.

Read Oracle Warehouse Builder 11g Book Review

 

This book is available for purchase at packtpub.com 

Oracle Warehouse Builder 11g: Getting Started  

---

---

Oracle Warehouse Builder 11g Getting Started  By  Bob Griesemer About the Author Bob Griesemer has over 27 years of software and database engineering DBA  experience in both government and industry solving database problems designing  and loading data warehouses developing code leading teams of developers and satisfying...
We have our entire source structures defined in the Warehouse Builder. But before we can do anything with them we need to design what our target data warehouse structure is going to look like. When we have that figured out we can start mapping data from the source to the target. So let s design our target structure. First we re going to take a look...
The dimensions become the business characteristics about the sales for example A time dimension— users can look back in time and check various time periods A store dimension— information can be retrieved by store and location A product dimension— various products for sale can be broken out Think of the...
Implementation of  a Dimensional Model in a Database We have seen how a dimensional model is preferred over a normalized model for designing a data warehouse. Now before we finalize our model for the ACME Toys and Gizmos data warehouse let s look at the implementation of the model to see how it gets physically represented in the database. There...
A multidimensional implementation or OLAP online analytic or analytical processing requires a database with special features that allow it to store cubes as actual objects in the database and not just tables that are used to represent a cube and dimensions. It also provides advanced calculation and analytic content built into the database to facilitate...
In the case of the ACME Toys and Gizmos Company we have seen that the main measure the management is concerned about is daily sales. There are other numbers we could consider such as inventory numbers How much of each item is on hand However the inventory is not directly related to daily sales and wouldn t make sense here. We can model an inventory...
The Warehouse Builder contains a number of objects which we can use in designing our data warehouse that are either relational or dimensional. OWB currently supports designing a target schema only in an Oracle database and so we will find the objects all under the Oracle node in the Project Explorer. Let s launch Design Center now and have a look...
There are a couple of ways we can go about creating our target user— create the user directly in the database and then add to OWB or use OWB to physically create the user. If we have to create a new user and if it s on the same database as our repository and workspaces it s a good idea to use OWB to create the user especially if we are not...
We ll follow the same steps as we did in the last chapter where we created the ACME_WS_ORDERS module. Right-click on the Oracle object under Databases and select New... from the pop-up menu to launch the Create Module Wizard and step through the process. We ll name this module ACME_DWH for ACME Data Warehouse. TIP An important difference between...
Looking at our Project Explorer window with our target Oracle module expanded we can see a number of objects that are available to us as shown here There are objects that are relational such as Tables Views Materialized Views and Sequences. Also there are dimensional objects such as Cubes and Dimensions. We just discussed relational objects...