mload in Informatica truncates float data type

Tools & Utilities
Enthusiast

mload in Informatica truncates float data type

I have float data type in sql server (SS) and float in Teradata (TD). I am reading from SS and pass directly to TD. If I use odbc, data moves as it. eg 1.2 moves as 1.2 in TD. But if I use mload in Informatica, it rounds data. So, 1.2 becomes 1.0, 1.5 becomes 2.0.
Does anyone know how to fix it? 1. without dropping table as data has been already loaded.
2. If there is no option other tan droppping table, how to do this? What data type should be specified or keeping float in TD how to do it?
1 REPLY

Re: mload in Informatica truncates float data type

In order to resolve this issue, you have to set following session propety in session:

session >Config Object> Custom properties>

set values as "OutputScientificToRedirectFF=Yes;"

Thanks,

Bikash