Hash Stage

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Hash Stage

Post by admin »

Im staging some data in universe. Some of the columns are decimal(12,3). When I view the data in uv stage or thru import table definitions, they look as expected. Eg. 120.000, 97.000, etc. I than use this table in hash stage for lookups, not with these columns as key. But when data is viewed thru hash stage, the decimal goes missing and the value, in my case, is now 1000 times more, 120000, 97000, etc. Its not only a viewing problem as using these columns in computation, DS thinks the value is 1000 times the actual value, as viewed in hash stage. Ive tried different data elements to no avail.

For now, Ill have to divide by 1000. Could this be a bug?

TIA
Hong
Locked