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.
Level:
Intermediate
Coverage:
Versions 9.2 and10g
Publication:
Online and hands-on
Intended audience:
Users who want to know how to use the mapping debugger.
Objectives
Learn how to enter the debug mode for a data flow.
Know the prerequisites and how to set up the data flow for debugging.
Be able to debug a data flow.
Pre-requisites
Know the ETL basics and how those apply to Warehouse Builder.
Be familiar with Warehouse Builder's architecture.
Content
The Warehouse Builder mapping editor was only introduced in the 9.2 release. Version 9.0.4 did not expose a mapping debugger. The materials below cover the mapping debugger in the 9.2 and 10g releases.
Component
Version
Estimated Duration (h)
Delivery
Availability
Watch the How to use the mapping debugger viewlet online
9.2 / 10g
0:15
March 2004
Read chapter 7 - Debugging Mappings - in the Warehouse Builder User's Guide
9.2 / 10g
0:45
March 2004
Go through Demo 11 - Mapping Debugger - in the hands-on demo*
9.2 / 10g
0:45**
March 2004
* Note: you may want to go through the OWB self-service
education - installation session on how to setup Warehouse Builder.
** Note: excluding setup, included in the demo document. Legend: = recorded, = online, = paper, = hands-on
= recorded,
