Oracle CLOB Insert

[rajesh90]

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

[Anonymous]

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