ORACLE WAREHOUSE BUILDER : WORKSHOP II

UPDATE : The next workshop will be held end of May! Classes are limited to 8 seats (very hands on) Email me to get registered…

Many of you know that I’ve been developing Workshop II, the follow on workshop to OWB : Workshop I. As always, it’s an intensive hands on workshop ensuring you come away with both SKILLS and knowledge. If any blog readers are in the greater Seattle area (or have always needed an excuse for a weekend here) consider taking this course. Email me directly if you’re interested, and I can help get you registered for the workshop
ORACLE WAREHOUSE BUILDER : WORKSHOP II

This course builds upon the basic skills in Workshop I, and students leave with enough knowledge to begin building their warehouse. Users progress beyond basic mappings and learn additional DML techniques. Additional ETL skills are developed and students learn how to use Set Operators, Custom PL/SQL, and leave with most of the logical operators to build their warehouse. OWB Execution is explored and students learn how to build Process Flows to sequence and monitor the execution of their ETL Mappings. Students learn how to deliver web interfaces to display their Runtime (DBAs) and Design (End Users) data. Students learn techniques for scheduling and executing OWB from SQLPlus (EM).

Course Objectives
After completing the course, students should:

  • Be able to build process flows, ensure that errors are properly detected and managed
  • Be able to deliver the Web Browser based applications (Runtime Audit Browser for DBAs, and Design Browser for End Users)
  • Understand and be able to Import and Export data from OWB (OWB Metdata and Discoverer Integration)
  • Understand the applicability of, and know how to use the following ETL operators (Splitter, SetOp, View, Transformations, Expressions)
  • Be able to perform common DML processing (Trunc/Ins, Update, Delete, Merge) in mappings
  • Understand how to, and be able to deploy custom procedures and
    functions
  • Know the composition and the applicability of the OWB provided
    transformations
  • Be able to create views, and materialized views within OWB
  • Know how to execute and monitor OWB mappings from SQL Plus/Enterprise Manager

Text and Materials
All materials are supplied to students at the beginning of each class.

Class Format
Classes consist of approximately 1.5 hours of lecture supported by slides and whiteboarding. The balance of the day, approximately 6.5 hours, is hands-on. Each students works on their own Linux server.

Prerequisites
To be successful students must be comfortable with basic Oracle skills. The following is a short list of the suggested but not required skills:

  • Be able to accomplish all the objectives in Workshop I. Attendance at Workshop I is not required, but suggested.
  • Understand what schemas are, how they relate to users
  • Understand basic DDL (create table, alter table, create sequence, create or replace package) and DML (select, insert, update)
  • Know how to connect to Oracle using both Localnames (tnsnames.ora) and JDBC (host/port/SID)
  • Students will benefit most when they have a basic understanding of dimensional modeling (Cubes/Facts/StarSchemas)