Post
teradata
Using Teradata Parallel Transporter and Export operator, exported the float value from table to flat file. If the digits right to the decimal is zero and digits after the decimal is non-zero, then
the data is converted to scientific notation.
Case 1:
Table : catalog_returns
Column :CR_RETURN_TAX
Actual value = 0.35
When this data is exported using TPT, the value gets converted to Scientific form and that value will be “3.50E-01” .
Case 2 :
Table : catalog_returns
Column : CR_RETURN_TAX
Actual value = 32.17
When the data is exported using TPT, the value is exported as is i.e. "32.17".
How to restrict the values getting converted to scientific form.
The values should be exported in the same format as the source.
Regards,
Rashmi
STILL GOT QUERIES?