Complex Schedule OWB

Uli Bethke June 29, 2008

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

Read More

Global Variables OWB

Uli Bethke June 21, 2008

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

Read More
1 95 96 97