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