Ravi,
Please download payloads at each step of PI pipeline (same them as .txt, please use notepad++). Please let us know, in which step you see 0.004 converted to 4E-03.
Hi, Use standard function formatNumber in your message mapping. Enter number of zeros in format number function equal to permissible length of your target JDBC field.
Additionally, To handle values with positive exponential values (for example 2E+07)use if else condition to check value greater than 1 and handle it accordingly.
Best Regards,
Amol
Add comment