How to change the data type of multiple columns with similar data type to a particular another data type?

Five Stars

How to change the data type of multiple columns with similar data type to a particular another data type?

Hi all

 

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. 

 

Thanks.

Ten Stars

Re: How to change the data type of multiple columns with similar data type to a particular another data type?

Suggestion, you allready tried:
- tOracleInput , There's a DBType (db) and a Type (java) which you could adjust in the input schema definition of the tOracle. This should work.
Or try...
- Did you place a tMap in between : OracleIn -> Java/tMap (convert) -> Greenplum , I thought this would map correct datatypes?!
Five Stars

Re: How to change the data type of multiple columns with similar data type to a particular another data type?

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.

Ten Stars

Re: How to change the data type of multiple columns with similar data type to a particular another data type?

I you work with (save)defined Schemas you could look into your workspace / <project> / metadata ... files are stored ... never tried to scrip it so make sure you backup / copy ... look at .item files ... this is the only thing i can think of.