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 ...