My Oracle Support Banner

How To Avoid Generation of "When (1=1)" when Not Supported By the Source Technology (Doc ID 791153.1)

Last updated on OCTOBER 11, 2023

Applies to:

Oracle Data Integrator - Version to [Release 10gR3]
Information in this document applies to any platform.


By default, when using a Loading Knowledge Module (LKM) in an Oracle Data Integrator (ODI) Integration Interface, the generated WHERE clause is starts with the following SQL snippet :

However, some Technologies (for example, the  Hyperfile Technology) do not support this SQL clause.

How is it possible to avoid the generation of the following SQL snippet (1=1)?


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

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

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