I have column defined as "number(18,2)". File is loaded in to table via ETL tool abinitio. when table is loaded via API utillity, data is populated as expected. But when Multiload or PT_load is used, we see discrepancies in data between file and table only for single digit numbers. i.e "7.00" is loaded as "0.70".
Teradata version 14.10 is used.
Help me with the suggestions.
Please move this discussion to the Tools section.
Next, what version of the applications were you running, and on what platform were you running?
When you say you were using Ab Initio and the table was loaded via the API utility, are you referring to TPTAPI?