let me know if you have any doubts.
You mean to say, here source is oracle db & target is XML file?
If yes, have you tried with "IKM XML Control Append" ?
See if this helps you : http://www.scribd.com/doc/88229941/ODI-XML-Integration
I reversed the XML and provided and Schema name as well , it has got 15 datastores as there are 15 elements in the XML.
im not sure how to proceed further. (do I have to load each of the datastore individually and then use them in a Package)
I even tried using odisqlunload , gave the necessary details but got error message stating : does not accept URL
Sorry, I should have read your question properly. How many hierarchy you have in the xml file ?
refer this vedio tutorial