Embedding SQL "Select" Statements in ODI Integration Interface Mappings with Microsoft SQL Server
(Doc ID 424056.1)
Last updated on DECEMBER 12, 2023
Applies to:
Oracle Data Integrator - Version 3.2.03.01 and laterOracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
Goal
In Oracle Data Integrator (ODI), with Microsoft SQL Server, it is possible to nest an SQL "Select" instruction within an initial Select statement , for example:
Is it possible to force ODI to generate such an SQL Statement?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |