Entries from Oracle Warehouse Builder (OWB) Weblog tagged with 'data quality'
Matching Abbreviations and Acronyms
A quick post on how to match data using composite match rules for matching abbreviations or matching acronyms. For example we want to match the following tokens; International Business Machines Intl Bus Machines IBM One of these is a full...
Why does it take forever to build ETL processes
ETL is a lengthy process... what can you do about it?
Want to learn more about the HP Oracle Database Machine?
Here is your chance, sign up now to attend the Oracle BIWA Summit 2008 Dec. 2-3. Attend this unique two-day IOUG Business Intelligence, Warehousing and Analytics (BIWA) SIG (www.oraclebiwa.org) event to gain the knowledge and information critical for success in...
Good Data Quality Read on Rittman-Mead's Blog, and validating input with data rules
There's a good read over on the Rittman-Mead Consulting blog on End-to-End data quality. OWB would be a good tool to implement parts of the solution they have in mind-- to do an initial DQ assessment, and to do cleansing...
Comments, questions and the forum
When going through the blog I noticed some comments actually are questions. Not sure if everyone knows, but there is a very active product forum on OTN. The link has changed over the past couple of weeks, so make sure...
Sizing an OWB system...
Should I even go here...? Maybe not, but one thing that I thought would be interesting to mention here is an avenue to take when you are struggling with sizing. Yes, this will have loads of disclaimers but might be...
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,...
KPIs or KQIs
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....
Match and Merge - Complex Deduplication Rules Part 1
Often the match and merge operator is completely missed by users in OWB. Turn the light on. It is probably the most powerful mapping operator in the operator set and it is in the Core ETL of OWB. OWB has...
Creating Data Rules in Scripting
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...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'data quality'.
