My Oracle Support Banner

How To Generate START WITH ... CONNECT BY Clauses In ODI Integration Interfaces For Parent-Child Relationships Between Records ? (Doc ID 1304908.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.
***Checked for ODI 11g compliance on 23-Jan-2013***


The START WITH ... CONNECT BY clause can be used to select data from relational table that contain hierarchical relationships between records (usually some sort of parent -> child, manager-> employee or object -> components relationship).

For example:

How can this be designed in Oracle Data Integrator (ODI) Integration Interfaces ?


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
 Solution 1. Using a CONNECT_BY option defined in the IKM
 Solution 2. Using a Flex Field defined on the Integration Interface object.

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