DSXchange

I tried using Dynamic RDBS or OCI stage to load into target Oracle table with XMLTYPE datatype. But the job was aborting. When i imported the table definition for this oracle table, for XMLTYPE datatype, it imported as unknown datatype.

I have the source column as Oracle CLOB datatype and Target is Oracle XMLTYPE datatype. Source CLOB column contains XML data which i need to extract and load into Target Oracle column with XMLTYPE datatype using Datastage 8.1 Parallel Job. I was able to read the source CLOB data using Dynamic RDBMS ...