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, you will need to have imported the DEMO_SRC and DEMO_TRG data models as described in the Preface.

How to do it...

Note

We begin by creating a temporary interface using a projection (list of columns) based on an inline view definition and managed...