Oracle Warehouse Builder (OWB) Weblog

OWB 11gR2 – Template mapping variables?

By david.allan on October 25, 2009 9:26 PM

Here we'll see how you can add runtime variables and reference them from code template mappings in OWB 11gR2; variables can be used in many places including expressions, filters, joiners and execution unit code template assignments. This lets you control...

| TrackBacks (0)

Good Data Quality Read on Rittman-Mead's Blog, and validating input with data rules

By antonio romero on October 29, 2008 1:00 AM

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

| TrackBacks (0)

Table Functions as Source and Target

By david.allan on June 3, 2008 12:13 AM

Using table functions is a useful way to both boost performance and extend the source/target capabilities in OWB. Here we will see how to setup table functions as a source and a target in OWB. Table functions let you define...

| TrackBacks (0)

Pivoting Data in OWB

By david.allan on March 17, 2008 11:21 AM

The pivot transformation operator enables you to transform a single row of attributes into multiple rows in an efficient manner. This example illustrates transforming a table that has a row for each year with the quarterly sales in a table...

| TrackBacks (0)

Binary Files in OWB - Simple Example

By david.allan on January 25, 2008 11:39 AM

So how do you load binary data into Oracle? Using a variety of ways, thats the good news, this is a little like teaching new dogs old tricks. OWB's file support is rich enough to fulfill the vast majority of...

| TrackBacks (0)

Match and Merge - Complex Deduplication Rules Part 1

By david.allan on August 28, 2007 10:53 PM

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

| TrackBacks (0)

File Listing/XMLType from a stored procedure

By david.allan on May 2, 2007 4:59 PM

Ever wondered how to get a list of file names in a directory from within the Oracle database? See post for more details on OWB. This is something I've done in 2 cases, one which happens to use the XML/SQL...

| TrackBacks (0)