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.
Highlighted
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

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.