Last updated on AUGUST 15, 2017
Applies to:Oracle Data Integrator - Version 220.127.116.11.6 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 18.104.22.168.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms