back to Course Categories | back | print
Oracle9i: Introduction to Warehouse Builder          

Duration: 3 days

Description 
This course will show DBAs and developers how to use the Oracle Warehouse Builder product to design and manage dimensional models and implement the physical data warehouse in the Oracle9i database. Students will learn how to create definitions for a logical model, and build processes that extract, transform and load data into the physical data warehouse. Students will also learn how to define and configure a physical instance of the data warehouse on Oracle9i using the Warehouse Builder Product. Upon completion of this course, the students will understand how to install and configure warehouse builder and use it for the design and maintenance of their Oracle9i data warehouse.

Topics

  • The development phases of building a data warehouse.
  • Installing and configuring Oracle Warehouse Builder.
  • Navigating the Oracle Warehouse Builder console.
  • The OWB repository.
  • Objects, projects and sessions.
  • Defining target modules.
  • Creating table, view and sequence definitions.
  • The elements of the dimensional model: dimensions, facts and measures.
  • Star and snowflake schemas.
  • Defining fact and dimension tables.
  • Defining source modules.
  • Importing data source definitions.
  • Working with ERP data sources.
  • Mapping data sources to targets.
  • Mapping operator attributes.
  • Using expression builder for transformations.
  • Working with flow operators.
  • Configuring, validating and generating mappings.
  • Defining and configuring a physical instance.
  • Using partitions and database links.
  • Implementing an indexing scheme.
  • Generating and deploying scripts.
  • Upgrading the physical instance.
  • Managing scripts.
  • Creating and scheduling workflows.
  • Using the Meta Data Loader utility.
  • Using Batch Services and the Transfer Wizard.
  • Change management for Oracle Warehouse Builder.
  • Reporting with the browser and client utilities.
  • Creating custom reports

Prerequisites

  • An solid of understanding of database concepts and technologies. Experience in developing database applications. A basic understanding of relational data modeling concepts. Experience writing and reading SQL.

    • This course covers the elemental concepts required to build a data warehouse using Oracle Warehouse Builder. This class is intended for DBAs and application developers that are currently or will be involved in the design and implementation of an enterprise data warehouse.

 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design