DSXchange

Hi

I am attempting to do change capture on SQL Server source into Oracle Target. The SQL Server has fields with type Real which gets imported into DataStage as type Float. When I run it through the change capture, I am getting differences even though the values are the same. Also it appears DataStage is rounding the value.

Here's an example:

SQL Server value: 134623.5
Oracle Value: 134623.5

However If I place this in a peek stage, it shows as: 134624

Any ideas?

You might like to search here and elsewhere to learn why computers can not precisely store real (sfloat or dfloat) numbers.

Convert to decimal before effecting any comparison - you can preserve the floating point numbers, but compare the decimal numbers.

Yeah that's the way I was going. Thanks Ray.