| Objectives |
 |
 |
Know the different operating modes and what they stand for. |
|
Understand the different code generation options. |
|
Know what is correlated commmit and how it can help design a mapping for restartability (this feature is not available in Warehouse Builder 9.0.4). |
|
Know about some design characteristics in Warehouse Builder with respect to the different operating modes. |
|
Learn about Warehouse Builder's support for Partition Exchange Loading (PEL). |
|
Be able to use SAP as a source and generate ABAP code. |
|
Know how to use Advanced Queues as source and target using Warehouse Builder. |
|
Know about Warehouse Builder's XML load capabilities. |
| Content |
|
| Version 9.0.4 introduced a new navigation tree on top of the design repository. As of this version, the design tree is a good starting point for an overview of the product. The materials below guide you through an overview of the rich functionality in the product. |
|
Component |
Version |
Estimated Duration (h)
|
Delivery
|
Availability |
|
Read the section Selecting a Default Operating Mode (3 pages) in chapter 11 - Configuring ETL Objects -, Strategies for Configuring PL/SQL Mappings of the Warehouse Builder User's Guide. |
9.0.4 / 9.2 / 10g |
0:20
|
 |
March 2004 |
|
Read the entire section Configuring Mappings Reference in chapter 11 - Configuring ETL Objects - of the Warehouse Builder User's Guide. |
9.0.4 / 9.2 / 10g |
1:00
|
|
March 2004 |
|
Read the section Committing Data from a Single Source to Multiple Targets (3 pages) in chapter 11 - Configuring ETL Objects -, Strategies for Configuring PL/SQL Mappings of the Warehouse Builder User's Guide (correlated commit was not available in version 9.0.4). |
9.2 / 10g |
0:20
|
|
March 2004 |
|
Review Avoiding Invalid Designs for PL/SQL Mappings (4 pages) in chapter 11 - Configuring ETL Objects -, Strategies for Configuring PL/SQL Mappings of the Warehouse Builder User's Guide. |
9.0.4 / 9.2 / 10g |
0:25
|
|
March 2004 |
|
Read the entire section Using Partition Exchange Loading in chapter 11 - Configuring ETL Objects -, Strategies for Configuring PL/SQL Mappings of the Warehouse Builder User's Guide. |
9.0.4 / 9.2 / 10g |
0:40
|
|
March 2004 |
|
Watch the viewlet How to Integrate SAP as a source with OWB. |
9.0.4 / 9.2 / 10g |
0:15
|
 |
March 2004 |
|
Read the section Using Advanced Queues in chapter 3 - Defining Oracle Data Objects - of the Warehouse Builder User's Guide. |
9.0.4 / 9.2 / 10g |
0:30
|
|
March 2004 |
|
Read the section Configuring Advanced Queues in chapter 5 - Configuring Data Objects - of the Warehouse Builder User's Guide. |
9.0.4 / 9.2 / 10g |
0:10
|
|
March 2004 |
|
Read the entire section Mapping Advanced Queue Operator in chapter 8 - Using Mapping Operators - of the Warehouse Builder User's Guide. |
9.0.4 / 9.2 / 10g |
0:25
|
|
March 2004 |
|
Read appendix C - Using the XML Toolkit - of the Warehouse Builder User's Guide. |
9.0.4 / 9.2 / 10g |
1:20
|
|
March 2004 |
= recorded,
= hands-on
