This session introduces the basic principles for designing process flows that establish interdependencies between ETL mappings and related activities.
Level:
Basic
Coverage:
Versions 9.0.4, 9.2, 10g
Publication:
Online and hands-on
Intended audience:
Users who want to use Warehouse Buider to design their dependencies in their BI system.
Objectives
Learn the process flow editor basics.
Be able to design a process flow.
Pre-requisites
None.
Content
Warehouse Builder provides a process flow editor to design dependencies between individual activities. The design can be generated into an XPDL (XML Process Definition Language) document that can be consumed by an execution engine. Out-of-the-box Warehouse Builder integrates with Oracle Workflow, a dependency engine in the Oracle database. The materials below teach you how to use the process flow editor design component. For deployment, refer to the related materials below.
Component
Version
Estimated Duration (h)
Delivery
Availability
Watch the Warehouse Builder process flow editor demo online*
9.0.4 / 9.2 / 10g
0:10
March 2004
Go through Demo 6 - Process Flow Editor - in the hands-on demo**
9.0.4
0:30***
March 2004
9.2 / 10g
0:30***
March 2004
* Note: you may have to disable your popup blocker in order to view the recorded demo.
** 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