 Oracle Warehouse Builder Self-service Education
Welcome to the Oracle Warehouse Builder Self-service Education! The training material on this site accelerates your learning process with Warehouse Builder and is free of charge. To provide you with the most up-to-date training materials, the content on this site is continuously being reviewed and updated. This site contains links to on-line training sessions, demos, white papers, and relevant product documentation. The training sessions and demos require you to work on-line, while the other content can be downloaded and read off-line. Legend:  = Basic, = Intermediate, = Advanced.
If you prefer an instructor-led training, then please refer to the Oracle University 4-day Warehouse Builder Implementation training. Note that this training is fee-based.
What are you looking for?
If you are already familiar with Warehouse Builder, but you want to learn more, and you know what you are looking for, then you may well find the subject index useful. |
| Getting started |
 |
| |
Title |
Level |
Description |
 |
Overview |
|
This session includes a high-level overview of Warehouse Builder, its capabilities, positioning in the market, and important reasons for using Warehouse Builder. |
|
Installation |
|
Refer to this topic to get started using Warehouse Builder's client and server-side components. |
|
New features |
|
Use this session to learn about features introduced in the 9.0.4 and 9.2 releases for Warehouse Builder. The Warehouse Builder 10g release includes all the features available in the 9.0.4 and 9.2 releases and is the first Warehouse Builder release compatible with the Oracle 10g database. |
back to top
| Design |
|
| |
Title |
Level |
Description |
|
Capture data source definitions |
|
Use this session to learn how to capture data from existing sources for use in your target business intelligence environment. |
|
Dimensional Modeling |
|
Most business intelligence environments benefit from dimensional models that optimize relational query performance in the database. Warehouse Builder is unique in that you can also deploy to the multi-dimensional Oracle OLAP server. Use this session to learn about dimensional modeling with Warehouse Builder. |
|
ETL Basics |
|
A business intelligence system typically provides a consolidated view across the enterprise. Use this session to learn how to design data flows that move data from source systems into your target environment you can use Warehouse Builder Extract, Transform and Load (ETL) features. |
|
Loading files |
|
This session describes how to use Warehouse Builder to load data from flat files into a target database. |
|
ETL debugging |
|
Beginning with the 9.2 release, Warehouse Builder enables you to debug the data flows you design in the Mapping Editor. Use this training session to learn how to debug mappings. |
|
Advanced ETL |
|
This session covers more advanced ETL capabilities Warehouse Builder provides. Use this session if you already know the basic concepts of design data flows, and you want to learn more about partition exchange loading, extraction from SAP, loading from and into queues, etc. |
|
Process Flow basics |
|
This session introduces the basic principles for designing process flows that establish interdependencies between ETL mappings and related activities. |
back to top
| Implementation |
|
| |
Title |
Level |
Description |
|
Deployment |
|
After designing data objects, mappings and process flows, implement the designs by deploying the mappings and process flows to the target environment. Use this session to learn about the deployment phase in Warehouse Builder. |
|
OLAP cube creation |
|
To design target data structures as dimensions in cubes in Warehouse Builder is very beneficial. Not only would relational queries benefit; Warehouse Builder also enables you to deploy to a multi-dimensional database: Oracle OLAP server. This component teaches you all about the integration. |
back to top
| Management |
|
| |
Title |
Level |
Description |
|
Runtime management |
|
In runtime management, you monitor the results of the execution of mappings and process flows. Use this session to learn about runtime management in Warehouse Builder. |
|
Life-cycle management |
|
Business intelligence systems do not live in a static environment. End-user requirements change, source systems impose changes on the environment, and eventually, you must update the target. Learn how Warehouse Builder helps you manage those changes. |
|
Metadata management |
|
This session covers the metadata management features that help you manage business intelligence design across multiple target environments and tools. |
back to top
| Data Quality |
|
| |
Title |
Level |
Description |
|
Name and Address cleansing |
|
If your business intelligence systems include name and address related data in the target environment, you may have the following concerns: Do the persons registered to an address live there, do the companies exist, and does the address exist? Also, if you do know the address, but you do not know the zip code, could you find out? Use this session to learn how to answer these questions using name and address cleansing in Warehouse Builder. |
|
Advanced de-duplication |
|
The aggregation of data from potentially multiple systems, or even a closer look to just one system, may bring up data quality issues. Case sensitivity, typos, misunderstandings or just simply different procedures can lead to multiple almost identical entries of the same information. This session teaches you how to de-duplicate your almost identical data using Warehouse Builder. |
back to top
| Scripting / APIs |
|
| |
Title |
Level |
Description |
|
Metadata manipulation using OMB scripting |
|
Use this session to learn how to use the powerful Warehouse Builder scripting language to efficiently perform actions on the metadata repository such as performing a mass update or performing a back up. |
back to top
| Reviewers Guide |
|
| |
Title |
Level |
Description |
|
Reviewer Guide for Warehouse Builder |
|
This section is particularly relevant if you are interested in evaluating Warehouse Builder or if you need to understand the basic functionality at a hands-on level. This comprehensive scenario walks you through an example, start to finish on how you can develop a Warehouse Builder system. The session covers many of the topics above integrated into a single flow and can help you understand how a typical project is done using Warehouse Builder. |
Legend: = Basic, = Intermediate, = Advanced
back to top
|
Bookmark
