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

Creating a temporary interface (subquery)

During normal application development, there may be times when the complexities of the functional requirements extend beyond the capabilities of a single ODI interface. To address these situations, and with the release of version 11g, ODI allowed temporary interfaces to be used as subqueries. Using a temporary interface allows developers to split up the complex logic into multiple interfaces. While a comprehensive list of use cases is impractical to mention here, this section will provide an example of one of the two basic types of temporary interfaces available:

  • Temporary interfaces using persistent data stores (target tables that already exist or will be created within the designated target schema)
  • Temporary ...

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