Five 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

 

  • Data Integration
Tags (2)
1 REPLY
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.