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