Oracle Data Integrator vs. Oracle Warehouse Builder: What to do, what to do?

Uli Bethke July 13, 2009

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes One of the questions that regularly comes up in the forums, or during presentations on Oracle data integration products, is on the future of Oracle Warehouse Builder and Oracle Data Integrator. People wonder which tool to ...

Read More

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

Uli Bethke November 12, 2008

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

Read More

Automate OWB Metadata export with OMB+

Uli Bethke July 21, 2008

I regularly make exports of Warehouse Builder Metadata to files. I do this at least once a day. When there are a lot of changes to OWB objects I make the export multiple times a day. I prefer this over snapshots as these exports to file do not fill up the OWB repository. Regular exports ...

Read More

Create and Maintain Source to Target Map in OWB

Uli Bethke July 11, 2008

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

Read More
1 2 3