PacktLib: Oracle Warehouse Builder 11g R2: Getting Started 2011

Oracle Warehouse Builder 11gR2: Getting Started 2011

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

An Introduction to Oracle Warehouse Builder

Introduction to data warehousing

Installation of the database and OWB

Summary

Defining and Importing Source Data Structures

Preliminary analysis

An overview of Warehouse Builder Design Center

Importing/defining source database object metadata

Summary

Designing the Target Structure

Data warehouse design

Data warehouse design in OWB

Summary

Creating the Target Structure in OWB

Creating dimensions in OWB

The Product dimension

The Store dimension

Creating a cube in OWB

Using the data object editors

Summary

Extract, Transform, and Load Basics

ETL

Staging

Mappings and operators in OWB

Summary

ETL: Putting it Together

Designing our staging area

Review of the Mapping Editor

Creating a mapping

Summary

ETL: Transformations and Other Operators

STORE mapping

PRODUCT mapping

SALES cube mapping

Features and benefits of OWB

Summary

Validating, Generating, Deploying, and Executing Objects

Validating

Generating

Deploying

Executing

Deploying and executing remaining objects

Summary

Extra Features

Metadata change management

Synchronizing objects

Warehouse Builder online resources

Summary

Code Template Mappings

Code templates

Connecting to SQL server using a JDBC database connection

Building a code template mapping

Summary

Index