r
rmohankumar4@dxc.com

Posted on 26th April 2024|67 views

0
votes

TPT - Export operator - Float value converted to scientific notation

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

 

 

Answers

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos