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!

Is there a way to add parallel hint(Parallel(4)) to Insert flow into I$ table step?

User_MCBIVDec 8 2020

The Insert flow into I$ table step is generating the following SQL but performance is slow so wondering if there is any way to add parallel hint:
* Detection Strategy: OUTER */INSERT /*+ append */ INTO BI_DW.I$_769471540_7
I'd like to see something like:
* Detection Strategy: OUTER */INSERT /*+ append parallel(4)*/ INTO BI_DW.I$_769471540_7
We are on ODI 11g with BIAPPS and using KM:IKM BIAPPS Oracle Fact Incremental Update
Thanks
Srinivas

This post has been answered by Marco Fris on Dec 9 2020

Jump to Answer

Added on Dec 8 2020

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

2 comments

676 views