Hi,
We are having query with Sum(Col1).
When we are trying to fetch records from Oracle Stage its showing warning possible truncation of scale from Decimal (38,10) to Decimal (38,2).
We changed column scale to Decimal(38,10) then it gives floating point error.
If we select column without any Sum it doesn't give any warning.
Is there possible resolution.
Floating Point Error
Moderators: chulett, rschirm, roy
Floating Point Error
Thanks,
Yuva.
Yuva.
What floating point error do you get after changing the scale?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I am still unsure of what your actuall error or warning is. You need to make sure that the Oracle stage produces a format that the stage can use. Have you tried using an Oracle CAST... function to ensure that the format of the SQL SUM() function is decimal(38,10)?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>