I need to load data from Oracle table which contains some of the columns having datatype as CLOB. My approach is to use Tmap where user defined Routine can be used to convert CLOB to String. But the main challenge I'm facing is which datatype should be selected in Talend schema for Oracle CLOB and then as per the selected datatype in talend, there is need to write the Routine to convert it to string.
Can anyone please suggest, what is the best way to handle the above scenario.
Appreciate your help!!
Use the Object class and convert to the appropriate class using Java. Either create a routine to handle your case or do it in a tJavaRow/tJavaFlex
For this, I used SQL query in tOracleInput component in Talend and put STRING datatype in talend for the column having CLOB datatype in Oracle. I know it will truncate the data if it's size exceeds 4000 chars, however followed this approach because I was not able to handle CLOB data in talend using any other datatype.