Book Review - Oracle Warehouse Builder 11G Getting Started - OWB for beginners

Uli Bethke Oracle Warehouse Builder

Bob Griesemer's Oracle Warehouse Builder 11G - Getting Started is the first and so far (as of Oct 2009) only book published on Oracle Warehouse Builder. It aims to introduce data warehousing in general and Oracle Warehouse Builder in particular, to absolute beginners in the field. In chapter 1 the author guides us through the installation process for OWB 11G. ...

Run Procees Flow from Command Line or SQL+

Uli Bethke Oracle Warehouse Builder

You can run a process flow from the command line. This is useful if you want to call a process flow from another application, e.g. if you want to use a 3rd party scheduler like AT or Cron etc. or if you want to script the execution of your process flows.

You need to call the sqlplus_exec_template.sql from sqlplus ...

Complex Schedule OWB

Uli Bethke Oracle Warehouse Builder

OWB has the By Clause to create complex schedules. Imagine you have a near real time ETL process that needs to execute every 15 minutes between 7 am and 0 am. You don't want this schedule to execute during the night because other maintenance operations such as stats gathering etc. need to run. Step 1: Create a schedule with your ...

Global Variables OWB

Uli Bethke Oracle Warehouse Builder

Several global variables can be accessed in a process flow. How this is done is not documented well. In the example below I have created two variables and assigned them values of the global variables Audit_ID and Number_of_Errors. Step 1: Create Process Flow and add two variables: l_audit_id and l_number_of_errors. For both variables select Integer as the data type. Step ...