Introduction to Oracle Warehouse Builder 10gR2

 Click here

Course Overview

Students participating in this 3 day hands-on course will learn the foundations of what a typical Data Warehouse oriented project entails with emphasis on the Extraction, Transformation, and Loading of data with Oracle Warehouse Builder. The basics of data warehousing methodologies and syntax are covered, as well as many diverse cases and uses of Warehouse Builder. A complete ETL lifecycle will be studied and built with hands-on exercises and demonstrations. The basic 3 day course is a solid foundation in Oracle Warehouse Builder techniques. Topics in the 3 day introduction include basic architecture, installation and setup, data profiling and quality, creating, deploying, and executing OWB mappings, and utilizing process flows.

Course Goals

• Provide students with the basics in Data Warehousing terminology and methodology.
• Explain how OWB fits into the lifecycle of a typical project, and highlight the areas for opportunity.
• Attain a working knowledge of Oracle Warehouse Builder (OWB) and how it facilitates loading data warehouses & marts
• Obtain foundational hands-on experience in OWB through rigorous lab exercises
• Understand the resulting PL/SQL scripts created from OWB, how to use them and how to troubleshoot them

Prerequisites

• Previous experience with the Oracle Database is required.
• Previous experience with basic SQL syntax is required.
• Previous experience with Oracle PL/SQL is not required, but very helpful.
• Previous experience with other ETL tools or Data Warehousing is not required, but helpful.

Who Should Attend?

• Application Developers
• PL/SQL Developers
• Technical Consultants
• Data Warehousing Architects
• ETL Developers
• Business intelligence Developers

Course Materials

• Oracle Warehouse Builder 10gR2 course materials

Duration

• Three (3) days

Course Outline

• Introduction to Basic Data Warehousing Concepts
• What is OWB?
• OWB 10gR2 Architecture and Configurations (install & setup)
• Exploring Warehouse Builder's Interfaces
• Defining Source Metadata
• Ensure Data Quality Using the Data Profiler
• Defining Staging Metadata and OWB Mappings
• Derivation of Data Rules and Running Correction Mappings
• Defining a Relational Dimensional Model (ROLAP)
• Slowly Changing Dimensions
• Process Flows
• Deployment, Loading, and Viewing of Data