data load in oracle db

Six Stars

data load in oracle db

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

 

 

Moderator

Re: data load in oracle db

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: data load in oracle db

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

Thirteen Stars

Re: data load in oracle db

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

Manohar B