PacktLib: Oracle Warehouse Builder 11g: Getting Started

Oracle Warehouse Builder 11 Getting Started

Credits

About the Author

About the Reviewers

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 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

Creating a cube in OWB

Using the Data Object Editor

Summary

Extract, Transform, and Load Basics

ETL

Staging

Mappings and operators in OWB

Summary

ETL: Putting it Together

Designing and building an ETL 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

Additional editing features

Warehouse Builder online resources

Summary

Index