Monday, June 05, 2006

OWB OBEs now available

Two new Oracle By Example (OBE) (link to page on OTN) tutorials on the recently released Oracle Warehouse Builder 10gR2 (10.2) have been made available on the Oracle Technology Network (OTN) by our Server Technology curriculum group. Both are estimated to take a little over six hours to run through, so they are comprehensive for someone who wants to take a look at a high level at all that this new release has to offer. And since these are OBEs, you could download the product and run through the examples alongwith the product, or simply go through the screenshots - the results should be the same in both cases. Of course if you run through the OBE screenshots only the exercise should take less time.

The first OBE is titled Introduction to Oracle Warehouse Builder 10g Release 2
  • Starting with Oracle Business Intelligence Warehouse Builder (approximately 15 minutes)
  • Working with Flat File Transactional Data (approximately 20 minutes)
  • Designing the Relational Target Warehouse (approximately 60 minutes)
  • Designing ETL Data Flow Mappings (approximately 60 minutes)
  • Deploying the Target Warehouse (approximately 30 minutes)
  • Loading the Target Warehouse (approximately 45 minutes)
  • Business Intelligence Modeling (approximately 20 minutes)
The second OBE is titled Migrating to Oracle Warehouse Builder 10g Release 2
In this Oracle By Example course, you get a step by step guide to migrating an existing system implemented using OWB 10gR1(10.1.0.4) to a new OWB 10gR2 environment. The objective of this migration process is not to scrap off your old system and re-build a new system using the latest OWB release. Rather, the objective is to smoothly move your existing system from OWB 10gR1 to OWB 10gR2 in order to give you the benefits of new capabilities as well as save on your investments and your time.
  • Setting Up the Environment for Migration (approximately 40 minutes)
  • Migrating Design Metadata to OWB 10gR2 (approximately 30 minutes)
  • Migrating Runtime Metadata to OWB 10gR2 (approximately 30 minutes)
  • Deploying the Migrated Dimensions and Cube (approximately 30 minutes)
Happy learning.