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 ??
