Oracle Warehouse Builder 10g: Implementation

What you will learn:

Audience:

• Business Intelligence Developer
• Business Analysts
• Data Warehouse Administrator
• Data Warehouse Analyst
• Data Warehouse Developer
• Database Administrators

Prerequisites:

Required Prerequisites:

• Oracle10g: Data Warehousing Fundamentals course, or prior DW experience or thorough familiarity with DW concepts
• Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL

Suggested Prerequisites:

• Oracle By Example: Warehouse Builder 10g R2: Getting Started
• eStudy: Introduction to Business Intelligence Products

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
• Deploy objects directly into Oracle Business Intelligence Discoverer EUL
• Model multi-dimensional dimensions and cubes
• Populate the Oracle database analytic workspace by using OWB
• Build an Expert
• Manage multiple named configurations
• Debug your mappings using the Mapping Debugger
• Use OracleBI Spreadsheet Add-In Microsoft Excel to connect to your Oracle OLAP data source
• Use OWB Change Manager to take “snapshot” versions of metadata, compare them, and restore them if necessary

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

Business Intelligence Integration

• Define Oracle Discoverer structures
• Derive Oracle Discoverer structures
• Define cross-tab and graph presentation templates

Understanding Oracle OLAP Concepts and Technology

• Benefits of using OLAP for end users and for information technology (IT) in general
• Key advantages of Oracle OLAP
• Main features of a dimensional model
• Role of an analytic workspace in the Oracle database

OWB OLAP Modeling and Deployment

• Use additional dimension-modeling capabilities –Value-based, ragged-level, skip-level hierarchies
• Design the multi-dimensional modeling

Using Spreadsheet Add-In to Query OLAP Data

• Use OracleBI Spreadsheet Add-In in Microsoft Excel
• Connect to your Oracle OLAP data source
• Create OLAP queries
• Use Excel features on OLAP data

Managing OWB Life-Cycle Changes

• Use OWB Change Manager to take “snapshot” versions of metadata, compare them, and restore them if necessary
• Use Metadata Dependency Manager to perform impact and lineage analysis

Using the Mapping Debugger

• Initialize a mapping debugging session
• Prepare the testing environment and test data
• Set breakpoints and watch points
• Run a test mapping
• Evaluate the flow of data to detect mapping errors

Managing the Warehouse Builder Environment

• Use OWB security management user interface
• Manage deployment and loading in a variety of configurations

Creating Experts

• Explain the benefits of Warehouse Builder Experts for novice users
• Use the Expert Editor to define an Expert