data load in oracle db

[YPMAL]

I have csv file with datatypes as follows :

column1,column2,column3,column4,column5 as

integer,  integer,   integer,   xmltype,  string

i want to load this in oracle db table

column1,column2,column3,column4,column5 as

integer,  integer,   integer,   xmltype,  string

Please tell me how to handle this xmltype column in tmap.

I know if only .xml file is for input we can use tfileinputxml but here one of the column is xmltype

sample input  .csv file

Name,Number,cdata,country

Yog,95,<xmldata>,india

Sample output oracle table 

Name  Number   cdata          country

Yog       95       <xmldata>     india

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[YPMAL]

Kindly Refer the updated staement. I have given sample Input Output

[manodwhb]

@yogeshmalekar,the XML type you convert into sting in tMap and populate to oracle.