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 load data from oracle table to XML using ODI ?

911461Jan 17 2012 — edited Jan 19 2012

Hello Team

I am trying to load data from an oracle table to an xml file. I have configured the physical and the logical schemas for the same. I have used SQL to SQL as LKM and SQL to SQL Append as IKM with Sunopsis Memory Engine as staging area.

After this, when I am executing the interface, it is executed without any errors but to my surprise I am not finding the relevant data in the xml file. What could be the reason ?

Please look into this and lemme know how to solve it.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2012

Added on Jan 17 2012

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

16 comments

803 views