Five Stars

Oracle CLOB Insert

Team,

I have source file with two columns,

PRODUCT_ID,COMMENTS
100,This is
100,First
100,Record
200,This is
200,second record
300,This is
300,third record
400,This is
400,record

Now I have used tdenormalize to transpose these columns based PRODUCT_ID. The output looks like below,

100,This is first record
200,This is second record
300,This is third record
400,This is fourth record

Note that the number of rows for PRODUCT_ID can be of any number.

What should be the datatype and length of the comments column in tdenormalise component, also now I need to insert this into an oracle table, PRODUCT, the datatype of the comments column in CLOB.
How to insert values into CLOB column in oracle database through Talend ?
Can you please let me know how to proceed further ??



Regards,
Rajesh
1 REPLY
Moderator

Re: Oracle CLOB Insert

Hello,

Set the datatype as 'Object' for CLOB column when define the schema in tDenormalize component.

Feel free to let us know if it is OK with you.

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.