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 JUNE 16, 2022

Applies to:

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

Goal

By default, when using a Loading Knowledge Module (LKM) in an 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)?

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


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