OWB Best Practice Part 1: Logically organise your DW project with Collections

Uli Bethke Best Practice, Oracle Warehouse Builder

Once you have gone beyond the implementation of more than one data mart for your Enterprise Data Warehouse project in Oracle Warehouse Builder, it becomes harder and harder to find a particular object for editing amongst the hundreds or thousands of objects. OWB Collections come to the rescue. They allow you to logically organise your project into virtual folders by ...

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

Create and Maintain Source to Target Map in OWB

Uli Bethke ETL, Oracle Warehouse Builder

One of the tasks during the ETL design process is to create a Source to Target Map. This maps fields from the source system to fields in the target data warehouse. Very often this is done in Excel. This approach has two disadvantages. First of all the definitions in the source to target map need to be transfered to your ...

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