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