topic Re: data load in oracle db in Talend Studio

data load in oracle db

YPMAL — Sat, 16 Nov 2024 09:27:57 GMT

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 — Mon, 07 Aug 2017 10:22:19 GMT

Hello,

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

Best regards

Sabrina

YPMAL — Thu, 27 Sep 2018 09:42:45 GMT

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

manodwhb — Thu, 27 Sep 2018 09:46:39 GMT

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