Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

with clause for recursive query

741405Sep 24 2014 — edited Sep 26 2014

In a mapping in ODI 12c I want to create a recursive query using a with clause. As I don't see any special type of object for implementing a with clause, I tried to use the CUSTOM_TEMPLATE property of the default "XKM Oracle Extract" Knowledge Module to override the generated code. Unfortunately, the select I applied in this property is not used.

Questions:

Is there another (better) way to implement an hierarchical/recursive query in a mapping?
Why isn't the sql in the CUSTOM_TEMPLATE picked up?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2014

Added on Sep 24 2014

#business-intelligence-applications, #data-integrator, #system-management-and-integration

5 comments

2,088 views