Entries from Oracle Warehouse Builder (OWB) Weblog tagged with 'BI'

Full Outer Joins in OWB

One of the questions I noticed recently was on full outer joins. How do you do that in OWB. Well it is quite simple, but I guess not that obvious. So here is a quick post on how to do...

Modifying icons for process flow activities

I would guess many people are using user defined activities in process flow. As do we when we do partner work. Wouldn't it be nice if you could change the icons for the user defined activities to better show what...

OWB, web services and the database

Since we get this question quite often, lets go back into this a little more. What is the story with OWB (or better the database) and web services? Well, you have all the tools and mechanisms around to simply hook...

Data Watch and Repair for Master Data Management

Some happy news on the data quality front (yes I'm harping on that quite a bit these days...). We just completed the new Data Watch and Repair solution using the entire OWB technology stack. One of the things we phased...

Checking referential integrity with data rules

So you read my KQIs thingie. This one is a bit more practical in that it is real code without coding :-)I get incoming data into a table, and what I want to do is check referential integrity without FKs,...