My Oracle Support Banner

How To Generate Ordered Joins with ODI? (Doc ID 424133.1)

Last updated on DECEMBER 01, 2023

Applies to:

Oracle Data Integrator - Version to [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.


How is it possible to use Oracle Data Integrator (ODI) to generate Ordered joins?

Example: When using ODI on Sybase ASE to generate an outer join, the '*' character is used to define the join clause. This syntax corresponds to a NON-ordered join clause. Sybase is capable of executing Ordered join operations but how is this done?


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.