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 10.1.3.4.0 to 10.1.3.4.0 [Release 10gR3]Information in this document applies to any platform.
Goal
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)?
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! |