O'Reilly logo

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial by Peter C. Boyd-Bowman, Bernard Wheeler, David Hecksel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with MySQL

In these step-by-step examples, we'll be adding product and inventory to our PO Processing data mart from a product system database which is hosted in MySQL. We're going to perform a mix of product data consolidation (combining base product and product category information from separate source tables into a single target table) and inventory data enrichment (converting a product number into a name).

To do this we will use two different methods in ODI 11g for joining information from two or more sources.

Since an ODI interface normally populates only one target datastore (though one of the newer 11g Knowledge Modules allows you to work around this limitation), we'll create two interfaces during this task—one for product information ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required