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?