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 ...
Get Oracle Data Integrator 11g Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
