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!

ODI Planning metadata load takes very long time

724393Sep 25 2009 — edited Sep 25 2009

Hi,

I am using ODI for Hyperion Planning metadata load.
We are facing performance issues, as the process is taking a very long time.

The process uses "LKM File to SQL" and "IKM SQL to Hyperion Planning"
The number of rows to process in the file is around 70000. The file is generated from DRM. The ODI integration process takes around 2 hours to process and load the file to Planning. Even if we add 1 new row to the file and everything else remains same in the file, the process takes that long.

So, the whole process takes around 3 hours to load to Planning for all dimensions.

I tried increasing the fetch rows to 200 in source but there is no significant increase in performance. The Heap size is set to maximum of 285 MB in odiparams.bat.

How can the performance be improved?
Can I use different LKM or change any other setting?

Thanks,
RS

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2009

Added on Sep 25 2009

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

6 comments

1,344 views