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!

Incremenatl Load for Financial Analyics using Informatica-Performance issue

716821Dec 14 2009 — edited Dec 15 2009

All

We are running an incremental loads for Financial Analytics from Oracle EBS 11.5.10.2 using Informatica 8.6. Our version of the OBIEE Apps is 7.9.6. Has anyone run into having to add indexes on LAST_UPDATE_DATE from several of the source tables such as AP_AE_HEADERS_ALL. We are analyzing performance issues with the ETL Queries for the incremental load and have realized that most of the queries are using LAST_UPDATE_DATE to extract the data from the source tables. Some of the source tables do not have an index on this field.

Has anyone run into this issue?

Thanks!

This post has been answered by 683289 on Dec 14 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2010

Added on Dec 14 2009

#business-intelligence-applications

2 comments

1,527 views