O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

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

Loading data from an SQL query

With the release of ODI 11g came two very important new features: the ability to specify an inline query in the form of a temporary interface and the ability to specify the use of an inline query within a knowledge module. Together, these two new features can be combined to provide developers with the ability to use any SQL expression as a data source to an interface. It is the intent of this recipe to demonstrate a simple example of this powerful capability.

Getting ready

To follow along with the examples listed here, you will need an ODI project with the following KMs: LKM SQL to Oracle, IKM SQL_as_Source (this module can be downloaded from the Packt website), and IKM Oracle Incremental Update. From a resource perspective, ...

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