StringToDecimal Conversion issue
Posted: Fri Feb 26, 2010 2:55 am
A question to the pros....
I've got a parallel job that is reading numbers (figures) from a varchar2 field of an oracle table and converting those figures into decimal(38,2) dataset field using the function stringtodecimal within a transformer.
When I check the dataset, the column contains only values like this 000000000000.00. I suspect that it may be related to some values that are not decimals (ex 23, 45, 78 ) but it's converting all the values into 000000000000.00 including the values the are decimals (43435.45, 234000.00).
Any clues?
Thanks
I've got a parallel job that is reading numbers (figures) from a varchar2 field of an oracle table and converting those figures into decimal(38,2) dataset field using the function stringtodecimal within a transformer.
When I check the dataset, the column contains only values like this 000000000000.00. I suspect that it may be related to some values that are not decimals (ex 23, 45, 78 ) but it's converting all the values into 000000000000.00 including the values the are decimals (43435.45, 234000.00).
Any clues?
Thanks