Page 1 of 1

Hash value in output

Posted: Mon Aug 13, 2012 5:06 am
by dnat
Hi,

I would like to output a key value(Like hash key) for the input which i send. For the same values i would need to get the same key values all the time.

For example

For the value "xyz, bg road" if a key is returned something like 9389494949, then everytime when i give the input the same key should be returned.

Is there any utility in datastage, parellel or server to achieve this?.

Even if it is in oracle or unix, it should be fine

Posted: Mon Aug 13, 2012 5:26 am
by ray.wurlod
The Checksum() function should achieve this result for small enough strings. (There's also a Checksum stage but I can't recall whether this existed in version 7.)