My Oracle Support Banner

How to Set Up Negative Join Operations in an ODI Integration Interface ? (Doc ID 742144.1)

Last updated on JUNE 16, 2022

Applies to:

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


Goal

How is it possible to set up ODI Integration Interfaces using the negative join (not in) operation between two tables ?

For example, how to set up the equivalent of the following SQL instruction :

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!


In this Document
Goal
Solution
 Using the LEFT OUTER JOIN operator
 Using the MINUS operator in a Database View
References


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