An oracle webservice is written to accept single record data. I have to map a data table to xml using odi and pass this xml as input to the webservice.
I created the xml/xsd file based on the webservice (wsdl). When I do reverse engineer, all the columns(basically elements) are created as table in the schema.
Target datastore will be xml and source will be the oracle table.
Since the xml is creating a table for each column how do I achieve this?