Oracle Warehouse Builder 11gR2

Importing/defining source database object metadata Part 3 (Oracle Warehouse Builder 11gR2)

Importing source database objects from a database We are now at the point where we can finally import our source database objects, source database objects. We’ll walk through the process of importing from an Oracle database, which is very similar to the process of importing from a non-Oracle database; so it will be a good […]

Importing/defining source database object metadata Part 4 (Oracle Warehouse Builder 11gR2)

Case sensitivity of column names in SQL Server We used all uppercase for the column names above because the Warehouse Builder defaults the case to upper for any column name that we enter. However, this could cause a problem later while retrieving data from the SQL Server tables using those column names if the case […]

Designing the Target Structure (Oracle Warehouse Builder 11gR2)

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 […]

Data warehouse design (Oracle Warehouse Builder 11gR2)

When it comes to the design of a data warehouse, there is basically one option that makes the most sense for how we will structure our database and that is the dimensional model. This is a way of looking at the data from a business perspective that makes the data simple, understandable, and easy to […]

Data warehouse design in OWB (Oracle Warehouse Builder 11gR2)

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 Projects tab. Let’s launch Design Center […]

Creating the Target Structure in OWB (Oracle Warehouse Builder 11gR2)

Now it’s time to actually start creating objects in the Warehouse Builder for our target structure. In the previous topic, we decided what our cube and dimensions were going to be in our logical design and now we are at the point where we can implement that design in OWB. We’ll create the objects using […]

Creating dimensions in OWB Part 1 (Oracle Warehouse Builder 11gR2)

The Warehouse Builder provides a couple of ways to create a dimension. One way is to use the wizards that it provides, which will automatically create a dimension for us. The other way is to manually create it. We have identified three dimensions that we are going to need a Date dimension, a Product dimension, […]

Creating dimensions in OWB Part 2 (Oracle Warehouse Builder 11gR2)

The Product dimension In the Product dimension, we will create the attributes that describe the products sold by ACME Toys and Gizmos. The principles of the Time dimension apply to this dimension as well. The same four characteristics need to be defined — Levels, Dimension Attributes, Level Attributes, and Hierarchies. The only difference will be […]

Creating a cube in OWB (Oracle Warehouse Builder 11gR2)

Now that we have our dimensions defined, we have one last step to cover and our design for our data warehouse will be complete. We need to define our cube, which is where our measures will be stored—the facts that users will want to query. We discussed the design of our cube and agreed that […]

Using the data object editors (Oracle Warehouse Builder 11gR2)

We’ve mentioned the Table Editor previously which is the data object editor for editing tables. We used it in topic 2 to create our source metadata definitions for the acme_pos transactional database, so let’s take this opportunity to look a little closer at the editors for a dimension and a cube. We’ll also discuss the […]