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

Last updated on OCTOBER 04, 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.

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

Applies to:

Goal

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!