https://community.qlik.com/t5/Talend-Studio/Oracle-CLOB-Insert/m-p/2331980#M100906 Team, <BR /> <BR />I have source file with two columns, <BR /> <BR />PRODUCT_ID,COMMENTS <BR />100,This is <BR />100,First <BR />100,Record <BR />200,This is <BR />200,second record <BR />300,This is <BR />300,third record <BR />400,This is <BR />400,record <BR /> <BR />Now I have used tdenormalize to transpose these columns based PRODUCT_ID. The output looks like below, <BR /> <BR />100,This is first record <BR />200,This is second record <BR />300,This is third record <BR />400,This is fourth record <BR /> <BR />Note that the number of rows for PRODUCT_ID can be of any number. <BR /> <BR />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. <BR />How to insert values into CLOB column in oracle database through Talend ? <BR />Can you please let me know how to proceed further ?? <BR /> <BR /> <BR /> <BR />Regards, <BR />Rajesh <BR /> Tue, 05 Sep 2017 13:37:43 GMT rajesh90 2017-09-05T13:37:43Z https://community.qlik.com/t5/Talend-Studio/Oracle-CLOB-Insert/m-p/2331980#M100906 Team, <BR /> <BR />I have source file with two columns, <BR /> <BR />PRODUCT_ID,COMMENTS <BR />100,This is <BR />100,First <BR />100,Record <BR />200,This is <BR />200,second record <BR />300,This is <BR />300,third record <BR />400,This is <BR />400,record <BR /> <BR />Now I have used tdenormalize to transpose these columns based PRODUCT_ID. The output looks like below, <BR /> <BR />100,This is first record <BR />200,This is second record <BR />300,This is third record <BR />400,This is fourth record <BR /> <BR />Note that the number of rows for PRODUCT_ID can be of any number. <BR /> <BR />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. <BR />How to insert values into CLOB column in oracle database through Talend ? <BR />Can you please let me know how to proceed further ?? <BR /> <BR /> <BR /> <BR />Regards, <BR />Rajesh <BR /> Tue, 05 Sep 2017 13:37:43 GMT https://community.qlik.com/t5/Talend-Studio/Oracle-CLOB-Insert/m-p/2331980#M100906 rajesh90 2017-09-05T13:37:43Z https://community.qlik.com/t5/Talend-Studio/Oracle-CLOB-Insert/m-p/2331981#M100907 <P>Hello,</P> <P>Set the datatype as 'Object' for CLOB column when define the schema in tDenormalize component.</P> <P>Feel free to let us know if it is OK with you.</P> <P>Best regards</P> <P>Sabrina</P> Wed, 06 Sep 2017 09:54:38 GMT https://community.qlik.com/t5/Talend-Studio/Oracle-CLOB-Insert/m-p/2331981#M100907 Anonymous 2017-09-06T09:54:38Z