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

Forteen Stars

Re: data load in oracle db

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog