Oracle - Course Details

OraWBI10g:P1 Oracle Warehouse Builder 10g: Implementation Part I

Oracle Course Description:
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.
Oracle Course Duration:
3 Days Training
Oracle Course Target Audience:
Business Analysts,Business Intelligence Developer,Data Warehouse Administrator,Data Warehouse Analyst,Data Warehouse Developer,Database Administrators
Oracle Course Prerequisite:
Oracle10g: Data Warehousing Fundamentals course, or prior DW experience or thorough familiarity with DW concepts,Oracle By Example: Warehouse Builder 10g R2: Getting Started,Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL,eStudy: Introduction to Business Intelligence Products
Course Content:
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
Business Intelligence Integration
  • Define Oracle Discoverer structures
  • Derive Oracle Discoverer structures
  • Define cross-tab and graph presentation templates