Microsoft SQL server Adapter returns scientific number from table
SummaryMicrosoft SQL server Adapter returns scientific number format 1.101984E7 instaed of 110198407
We have configured MSSQL adapter to read data from a table.Refer below screenshot. Screenshot1 from the Integration Payload and Screenshot2 is from Table
1. Why MSSQL adapter converts the number
2. To convert back to original number we tried with number(). But this is working when we use Assign activity, in Mapper activity it is not working.