Oracle Warehouse Builder 10g Release 2: Oracle by Example Series

Purpose

This page lists all of the OBEs for the Oracle Warehouse Builder 10g Release 2. The OBEs are divided into 3 sections, with the lessons listed in the order in which they should be taken.

The three sections are:

Oracle by Example Series:

Note: This version of the 'Getting Started' Oracle by Example series is written for OWB 10g Release 2, with differences in setup scripts, screenshots, and text from the previous version of OWB 10g Release 1, or subsequent versions of OWB 11g Release 1 and 2.

Oracle Warehouse Builder 10g Release 2: Getting Started

Oracle Warehouse Builder 10g Release 2 is an enterprise business intelligence integration design tool that manages the full life cycle of data and metadata for Oracle Database 10g. It provides an easy-to-use, graphical environment to rapidly design, deploy, and manage business intelligence systems. Oracle Warehouse Builder 10g:

  • Enables the extraction, transformation, and loading of data to produce quality information in the Oracle database
  • Protects and leverages customer investment in the Oracle technology stack through data and metadata integration

You learn how to use Oracle Warehouse Builder to design, build, and manage your data warehouse, data mart, or business intelligence system. The prototype throughout the product is that you import definitions, define target structures, validate the structures, generate the code to implement the structures, and deploy the structures to the target environment. After it is deployed, Warehouse Builder assists in the daily maintenance as well as monitoring of the deployed system. You learn how Warehouse Builder leverages your Oracle database investments and integrates with other Oracle tools.

Click the links below to open each lesson. To successfully complete the hands-on steps, work through the lessons in the order given below.


List of Lessons
1 Starting with Oracle Warehouse Builder 10g Release 2
2 Working with Flat File Transactional Data
3 Designing the Relational Target Warehouse
4 Designing ETL Data Flow Mappings
5 Deploying Objects in the Target Warehouse
6 Loading the Target Warehouse
7 Business Intelligence Modeling

Oracle by Example Series:

Oracle Warehouse Builder 10g Release 2: Extending Your Knowledge

Note: This version of the 'Extending Your Knowledge' Oracle by Example series is written for OWB 10g Release 2, with differences in setup scripts, screenshots, and text from the previous version of OWB 10g Release 1, or subsequent versions of OWB 11g Release 1 and 2.

Oracle Warehouse Builder 10g Release 2 is Oracle’s industry leading enterprise business intelligence integration design tool. It provides an easy to use, graphical environment to rapidly design, deploy, and manage business intelligence systems.

This series of OBE tutorials walks you through a data profiling exercise, allowing you to correct data based on detected business rules. In addition, the tutorials show how you can match and merge duplicate data using Warehouse Builder. Other topics include ETL on complex data types, modeling of schemas in the Oracle database (includes partitioning, indexing, and compression). And finally, the tutorials show how to augment Warehouse Builder with Experts, allowing you to encapsulate business knowledge into Warehouse Builder.

Click the links below to open each tutorial. The setup tutorial is a prerequisite for all of the other tutorials; once the setup tutorial has been completed successfully, you may perform the rest of the tutorials in any order.


List of Lessons
1 Setting up the Oracle Warehouse Builder Project
2 Examining Source Data Using Data Profiling
3 Matching and Merging Records
4 Extracting, Transforming and Loading Data
5 Modeling the Target Schema
6 Using Experts to Automate Warehouse Builder Tasks

Oracle by Example Series:

Oracle Warehouse Builder 10g Release 2: Migrating from OWB 10g R1 to OWB 10

Note: This version of the 'Migrating from OWB 10g R1 to OWB 10g R2' Oracle by Example series is written for OWB 10g Release 2, with differences in setup scripts, screenshots, and text from the previous version of OWB 10g Release 1, or subsequent versions of OWB 11g Release 1 and 2.

This set of OBE tutorials teaches you how to migrate from Oracle Warehouse Builder 10g Release 1 to Release 2. Work through the lessons in the order given below.


List of Lessons
1 Setting Up the Environment for Migration
2 Migrating Design Metadata to OWB 10gR2
3 Migrating Runtime Metadata to OWB 10gR2
4 Deploying the Migrated Dimensions and Cube