Oracle Warehouse Builder 11g: Getting Started Table Of Contents

Back to BOOK PAGE

Table of Contents

Preface
Chapter 1: An Introduction to Oracle Warehouse Builder
Chapter 2: Defining and Importing Source Data Structures
Chapter 3: Designing the Target Structure
Chapter 4: Creating the Target Structure in OWB
Chapter 5: Extract, Transform, and Load Basics
Chapter 6: ETL: Putting it Together
Chapter 7: ETL: Transformations and Other Operators
Chapter 8: Validating, Generating, Deploying, and Executing Objects
Chapter 9: Extra Features
Index

• Preface

• Chapter 1: An Introduction to Oracle Warehouse Builder
  • Introduction to data warehousing
    • Introduction to our fictional organization
    • What is a data warehouse?
    • Where does OWB fit in?
  • Installation of the database and OWB
    • Downloading the Oracle software
    • A word about hardware and operating systems
    • Installing Oracle database software
    • Configuring the listener
    • Creating the database
    • Installing the OWB standalone software
    • OWB components and architecture
    • Configuring the repository and workspaces
  • Summary

• Chapter 2: Defining and Importing Source Data Structures
  • Preliminary analysis
    • ACME Toys and Gizmos source data
    • The POS transactional source database
    • The web site order management database
  • An overview of Warehouse Builder Design Center
  • Importing/defining source metadata
    • Creating a project
    • Creating a module
      • Creating an Oracle Database module
      • Creating a SQL Server database module
    • Importing source metadata from a database
    • Defining source metadata manually with the Data Object Editor
    • Importing source metadata from files
  • Summary

• Chapter 3: Designing the Target Structure
  • Data warehouse design
    • Dimensional design
      • Cube and dimensions
    • Implementation of a dimensional model in a database
      • Relational implementation (star schema)
      • Multidimensional implementation (OLAP)
    • Designing the ACME data warehouse
      • Identifying the dimensions
      • Designing the cube
  • Data warehouse design in OWB
    • Creating a target user and module
      • Create a target user
      • Create a target module
    • OWB design objects
  • Summary

• Chapter 4: Creating the Target Structure in OWB
  • Creating dimensions in OWB
    • The Time dimension
      • Creating a Time dimension with the Time Dimension Wizard
    • The Product dimension
      • Product Attributes (attribute type)
      • Product Levels
      • Product Hierarchy (highest to lowest)
      • Creating the Product dimension with the New Dimension Wizard
    • The Store dimension
      • Store Attributes (attribute type), data type and size, and (Identifier)
      • Store Levels
      • Store Hierarchy (highest to lowest)
      • Creating the Store dimension with the New Dimension Wizard
  • Creating a cube in OWB
    • Creating a cube with the wizard
  • Using the Data Object Editor
  • Summary

• Chapter 5: Extract, Transform, and Load Basics
  • ETL
    • Manual ETL processes
  • Staging
    • To stage or not to stage
    • Configuration of a staging area
  • Mappings and operators in OWB
    • The canvas layout
    • OWB operators
      • Source and target operators
      • Data flow operators
      • Pre/post-processing operators
  • Summary

• Chapter 6: ETL: Putting it Together
  • Designing and building an ETL mapping
    • Designing our staging area
      • Designing the staging area contents
      • Building the staging area table with the Data Object Editor
    • Designing our mapping
      • Review of the Mapping Editor
      • Creating a mapping
  • Summary

• Chapter 7: ETL: Transformations and Other Operators
  • STORE mapping
    • Adding source and target operators
    • Adding Transformation Operators
    • Using a Key Lookup operator
      • Creating an external table
      • Creating and loading a lookup table
      • Retrieving the key to use for a Lookup Operator
      • Adding a Key Lookup operator
  • PRODUCT mapping
  • SALES cube mapping
    • Dimension attributes in the cube
    • Measures and other attributes in the cube
    • Mapping values to cube attributes
      • Mapping measures' values to a cube
      • Mapping PRODUCT and STORE dimension values to the cube
      • Mapping DATE_DIM values to the cube
  • Features and benefits of OWB
  • Summary

• Chapter 8: Validating, Generating, Deploying, and Executing Objects
  • Validating
    • Validating in the Design Center
    • Validating from the editors
      • Validating in the Data Object Editor
      • Validating in the Mapping Editor
  • Generating
    • Generating in the Design Center
    • Generating from the editors
      • Generating in the Data Object Editor
      • Generating in the Mapping Editor
  • Deploying
    • The Control Center Service
    • Deploying in the Design Center and Data Object Editor
    • The Control Center Manager
      • The Control Center Manager window overview
      • Deploying in the Control Center Manager
  • Executing
  • Deploying and executing remaining objects
    • Deployment Order
    • Execution order
  • Summary

• Chapter 9: Extra Features
  • Additional editing features
    • Metadata change management
      • Recycle Bin
      • Cut, copy, and paste
      • Snapshots
      • Metadata Loader (MDL) exports and imports
    • Synchronizing objects
      • Changes to tables
      • Changes to dimensional objects and auto-binding
  • Warehouse Builder online resources
  • Summary

• Index

Back to BOOK PAGE