This course teaches delegates the fundamentals of Oracle Warehouse Builder 10gR2 development, including initial project and database setup, data modeling, data mapping and creation of process flows. It shows how projects are deployed from development environments to production, and explains how features in the Enterprise ETL and Data Quality Option are used alongside the ETL Core features to build complete data warehouses on the Oracle Database 10g
platform.

Topics covered in this 3-day course include:

  • Initial installation and database preparation
  • Creation of the repository and additional Control Centers
  • Configurations & Security
  • Data Modelling and OLAP development
  • Data Mapping & Process Flows
  • Use of Enterprise ETL functionality
  • Data Quality, Data Rules and Error Handling
  • Deployment to Production
  • Managing Metadata Changes
  • Automating the ETL build using OMB*Plus
  • Integration with Oracle BI Discoverer
  • Integration with Oracle Data Integrator
  • Tips & Best Practices
  • Discussion & Delegate Questions

This course is delivered by either Mark Rittman or Jon Mead, two consultants and experts on Oracle Warehouse Builder with over 10 years joint experience with the product. The course includes slides and delegate notes, and can be delivered on-site or through partner organizations.

The course is provided for a fixed price for up to 10 delegates, for locations in UK, Ireland and Europe. Quotations can be provided for custom versions of this course using your own data, and for delivery of this course in North America and other locations.

To book this course for your organization, or for more information, contact training@rittmanmead.com