My Oracle Support Banner

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

Last updated on NOVEMBER 13, 2019

Applies to:

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


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

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.