Oracle Warehouse Builder 10g

 Click here

Course Overview

Course Goals

• To instruct how to use OWB as your main ETL toolset.
• To have practical use of OWB by implementing them in lab step by step exercises.
• To facilitate discussion of student questions about the concepts and implementation of OWB.

Prerequisites

• SQL and PL/SQL
• RDBMS understanding

Who Should Attend?

• Developers

Course Materials

• Oracle Warehouse Builder 10g Users Guide

Duration

• Three days

Course Outline

• Overview
  • Describes the overall product
  • How to logon
  • The main console
  • Preferences
• Getting Started with Warehouse Builder
  • How to start building projects
• Defining Source and Target Objects
  • Creating and configuring the metadata definitions
• Defining Oracle Data Objects
  • Create definitions for relational and dimensional target objects
• Importing Data Definitions
  • Import definitions for data sources
• Configuring Data Objects
  • Assign physical properties
• Designing Mappings
  • Create and design mappings
• Using Mapping Operators
  • Details how to use different operators in a mapping to transform data
• Transformations
  • How to import, create and use transformations in mappings
• Configuring ETL objects
  • Describes how to configure mappings and process flows for deployment to a specific database instance
• Deploying and executing
  • Deploying the objects you have defined and executing the processes
• Validating Objects
  • How to verify the integrity of the objects
• Deploying Target Systems
  • How to deploy the physical instance of your target data system
• Auditing Deployment and Execution
  • Warehouse Builder's web-based Runtime Audit Browser
• Warehouse Builder Installation Requirements s
  • Verify your system requirements
• Installing Warehouse Builder
  • Step-by-step instructions for a typical installation
  • How to de-install the Warehouse Builder