DSXchange

Hi,

We are working in version 7.1 on Windows. We would like to know if there are any known compatibility issue of 'Decimal' values between Hashed File stage and UniVerse stage.

We write data to a Hashed File where the metadata for a column is Decimal(9,6). A sample value written to this column is 75. When we give View Data, we are able to see the correct value '75'.

we read the same hashed file from an UniVerse stage using the same metadata [Decimal(9,6)]. But when we use View Data, it shows a message that the "Expected = Decimal and Actual = Numeric", though it was written as a Decimal value. And also the value is shows after this message is "0.000075". It adds 6 decimal places to the actual value.

Is there any compatibility probelm between a Hahsed File stage and an UniVerse stage for a Decimal value been identified?

Thanks.

Life is easier when you make it a varchar then it does not change it.

Did you write the value using a UniVerse stage, or using a Hashed File stage?

Writing using a Hashed File stage and reading using a UniVerse stage can cause the scale to be interpreted as a "scaling factor".

UniVerse tables treat Numeric and Decimal identically, but for some reason always throw this warning if your metadata specifies Decimal. Import the table definition from the UniVerse table - you will get Numeric.

I write the value using a Hashed File stage and read it through a UniVerse stage.

So, you mean that in this kind of scenario, we will be getting this warning message whenever we make use of a Decimal column.

So, does it mean that I should try avoiding making use of Decimal datatype wherever I write to a Hashed File read it using UniVerse stage?

I had this issue resolved.

While writing to the Hashed File stage, I checked the option "UniVerse Stage Compatibility" in the Stage properties. Then, when I read it using a UniVerse stage, it reads the Decimal fields correctly.

Thanks.