Basic Transformer Numeric datatype
Posted: Fri Sep 30, 2016 1:54 pm
We have some server jobs migrated from 7.5 days and now in 11.5.0.1. these jobs were using drs plugin and now the drs connector replaced them.
this actually exposed a bug(?) in the basic transformer stage.
essentially we have 2 numeric fields define as 19,8. these will be multipled and result stored in another numeric field of 19,8
365.76000000*0.75357800*0.8
this results in 220.5029514240000000 and when writtent o Numeric 19,8 field in the transformer expect it to convert it to 220.50295142. however until its not written to a file or target database, the transformer doesnt seem to convert it.
when we write to a file, the value is 220.50295142, but when we write to target we get the error from odbc driver "String data, right truncate"
if we write to file and then read the file to load the same table using the same driver, it works fine.
is this a old bug? please let me know
this actually exposed a bug(?) in the basic transformer stage.
essentially we have 2 numeric fields define as 19,8. these will be multipled and result stored in another numeric field of 19,8
365.76000000*0.75357800*0.8
this results in 220.5029514240000000 and when writtent o Numeric 19,8 field in the transformer expect it to convert it to 220.50295142. however until its not written to a file or target database, the transformer doesnt seem to convert it.
when we write to a file, the value is 220.50295142, but when we write to target we get the error from odbc driver "String data, right truncate"
if we write to file and then read the file to load the same table using the same driver, it works fine.
is this a old bug? please let me know