I am trying to load the data from Oracle to Greenplum database using Talend DI 7.0.1 version (tOracleInput -> tGreenplumOutput). I am getting error with the big decimal data type (DEC) while loading. If I convert type of the DEC to double using tConvertType, the data is getting loaded without errors. However I have hundreds of columns and I am finding it extremely difficult to look each and every column with DEC data type and change it to double in the target load.
Is there a way by which I can say Talend to Convert all the columns with dec data type to a desired target data type like double so that I don't need to go over each and every column.
I am able to explicitly cast types in the input schema definition.. but that again requires me going to every column and changing it. I am not able to apply something universal.
I tried tMap, but that requires changing type of every column. I am a newbie to Talend, so not sure if there is any other way by which we could do this in tMap.
None of the in-built auto conversions work. The data load fails unless I fix the column data type to something that could be transferred.