Skip to Main Content
Forums

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!

How to clear cache for XML data source?

459245Mar 10 2011 — edited Mar 11 2011
Hi All,

I'm facing a problem loading XML data into Oracle using Oracle Data Integrator. The problem is ODI will cache the data of the XML file at the first time loading the data. And afterwards, when the XML file changed, ODI will load data from the cache.

I did serveral testing on this. If I run the interface in local agent of the designer, I must restart the designer to clear the cache. If I run the interface in an agent, I must restart the agent to clear the cache.

Below is my configuration:
ODI version: 10.1.3.5.0
The technology of the source: XML.
JDBC driver: com.sunopsis.jdbc.driver.xml.SnpsXmlDriver

Does anybody know how to clear the cache of the agent or XML?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2011
Added on Mar 10 2011
#business-intelligence-applications, #data-integrator, #system-management-and-integration
3 comments
715 views