DSXchange

I am trying to extract two columns from Oracle database, one of which is a CLOB field storing XMLs. The task I want to accomplish is to get those XMLs and then map the elements of the XML to columns of a dataset. Please guide me how to design the job to accomplish this. Thanks in advance.
I am using Datastage 8.5.

You can write it to a sequential file as is and create another job to treate it as XML input file and read the data.