Back
 

Oracle Warehouse Builder Course

iWare Logic > Training  > Course Catalog > Oracle Warehouse Builder Course
This hands-on course helps the student in exploring the concepts, design issues, architecture, and terminology related to Oracle Warehouse Builder 11g, Release 2. It covers basic ETL activities using the subset of OWB functionality included in the Oracle Database 11g, Release 2 license. Beyond the basic ETL activities it also covers advanced ETL, data integration, and data warehousing functionality in Oracle Warehouse Builder.
This course is intended for:

  • Business Intelligence Developer
  • Data Warehouse Developer
  • Data Warehouse Analyst
  • Data Warehouse Administrator
  • Developer
  • Support Engineer
Course Description:

This is an intensive 3-day Oracle Warehouse Builder training course. This is Warehouse Builder class.

Key Features:

  • Understand Workflow and the Warehouse Builder viewer
  • Get started fast with Oracle Warehouse Builder
  • See examples of using Oracle Warehouse Builder for data cleansing
  • Use Oracle Warehouse Builder for OLAP integration
  • Learn how to implement Oracle Warehouse Builder scripting

Total Duration: 3 Days

What you will learn:
n this 3-day hands-on course, students learn how to implement a data warehousing solution using Oracle Warehouse Builder (OWB). The concepts, design issues, architecture, and terminology that underlie OWB are explored. Students
use OWB client tools to create and maintain OWB design metadata, including source and warehouse target definitions, and ETL mappings to extract, transform, and load data into the targets. Students generate, deploy, and execute OWB design objects to create and populate a target warehouse. This course focuses on relational dimensional modeling. This course serves as the prerequisite for Oracle Warehouse Builder 10g: Implementation Part 2. That course focuses on MOLAP modeling, and additional features of OWB.
Learn To: Extract, transform, and load data into the staging tables and an enterprise model warehouse Create Data Profile Generate Data Rules and Run Correction Mappings Define source-to-target mappings Design the target warehouse Create Process Flows
Target Audience:
  • Business Analysts
  • Business Intelligence Developer
  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Data Warehouse Developer
  • Database Administrators
Course Objectives:
  • Create Data Profile
  • Generate Data Rules and Run Correction Mappings
  • Define source-to-target mappings
  • Designing the target warehouse
  • Create Process Flows
  • Extracting, transforming, and loading data into the staging tables and an enterprise model warehouse
  • Create Schedules
  • Use the Dependency Manager to manage metadata
Course Topics:
Setting Up and Starting Warehouse Builder
Describe typical Oracle Warehouse Builder configurations, including the classroom stand-alone setup
Describe Oracle Warehouse Builder program group components
Log in to the Design Center
Create a design repository and users
Open a project and navigate the user interface

Introducing OWB 10g R2 Architecture and Configuration
Discuss various design and run-time configurations
Describe the Warehouse Builder repository architecture, users, and owners
Describe the OWB repository architecture, users, and owners
Explain the benefits of warehouse staging areas
Describe the course data sources and targets
Import metadata using tcl scripts

Defining Source Metadata
Define and create source modules
Specify source data from flat files
Specify source data from relational database tables
Import source object metadata into the source modules

Ensuring Data Quality Using Data Profiling
Create a data profile
Profile the data
View profile results
Analyze profile results

Defining Staging Metadata and Mapping Tables
Create a target module
Add a staging table to a staging area warehouse module
Define mappings between source objects and staging table columns

Deriving Data Rules and Running Correction Mappings
Derive data rules
Create a correction
Run the generated correction mappings

Defining a Relational Dimensional Model
Define dimensions and cubes
Navigate the Data Object Editor
Define ETL mappings to load the dimensions and cubes

Handling Slowly Changing Dimensions
Explain how OWB handles a slowly changing dimension
Define a type 2 slowly changing dimension
Use the type 2 policy dialog box

Using Process Flows
Navigate the process flow editor
Create process flow definitions
Define a schedule
Use process flow activity templates
Use process flow activities

Deploying, Loading, and Viewing Data
Use the Control Center Manager
Load data into tables
Use the Dependency Manager to manage metadata

We at iWareLogic run classroom sessions at locations across India and also offer quick start and custom courses. To discuss your training requirements, or if you are interested in a course which isn’t listed here, contact at info@iwarelogic.com to get in touch with a representative of our training team to discuss your needs.