ODI Enhancement Request: Request to Bring Back Temporary Interfaces, Also Known as "Yellow Interfaces" (Doc ID 2293193.1)

Last updated on AUGUST 15, 2017

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 and later
Information in this document applies to any platform.

Goal

In earlier releases of Oracle Data Integrator (ODI), the temporary interfaces, also called "yellow" interfaces, allowed developers to dynamically create tables within the mapping, but without having to materialize these tables in a model. Furthermore, when the temporary interface was used in a mapping it was possible to either continue to create the table, or to bypass the table and use the temporary interface as a sub-query.

In ODI 12c, part of the functionality of temporary interfaces was replaced by reusable mappings. However, reusable mappings require an ODI model to exist.

This is a request to bring back temporary interfaces or "yellow" interfaces into 12.2.1.2.6

Currently, Global Temporary tables need to be created for this behavior. Temporary tables are generally a better descriptive and declarative way than explicit Global Temporary Tables. It will save time and maintenance needs.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms