Oracle Warehouse Builder (OWB) Weblog

Data Watch and Repair for Master Data Management

By jean-pierre.dijcks on May 19, 2008 11:38 AM

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

By jean-pierre.dijcks on April 17, 2008 6:45 PM

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

Comments (2)

KPIs or KQIs

By jean-pierre.dijcks on April 14, 2008 4:53 PM

We all know what a KPI is, but what on earth is KQI? Well I just dreamed that up... but hang in there. This might get fun after all...Common data quality tooling these days has you do the data profiling....

Comments (1)

Creating Data Rules in Scripting

By david.allan on June 19, 2007 4:36 PM

Here are a bunch of examples for creating data rules from OMB, this will be a useful cheat sheet for anyone generating rules from any repositories where the rules already exist. You can download a tcl file which creates the...

Comments (1) | TrackBacks (0)