Floating Point Error

yuva010 · Post by **yuva010** » Thu Oct 02, 2008 3:14 am

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.

ArndW · Post by **ArndW** » Thu Oct 02, 2008 6:17 am

What floating point error do you get after changing the scale?

yuva010 · Post by **yuva010** » Fri Oct 03, 2008 1:14 am

Its warning rather, it says, possible loss of data.

ArndW · Post by **ArndW** » Fri Oct 03, 2008 7:05 am

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)?

yuva010 · Post by **yuva010** » Fri Oct 03, 2008 9:02 am

We didn't used any Cast function, because
Select Col1, Col2 from Table1 ---- Works fine
Select Sum(Col1), Col2 from Table1 group by Col2 ---- gives error.

Col1 is decimal (38,2)

We tried with Server Job, it works fine.