multiple reference records from hash file

rejith.ry · Post by **rejith.ry** » Wed Jan 31, 2007 1:15 am

Hi,
I am using a lookup(using transfromer) in server job on a hash file. For each input record, I want to extract multiple records from the hash file. The moment I make any column as the key, the duplicates are removed from the hash file.

Please help

ray.wurlod · Post by **ray.wurlod** » Wed Jan 31, 2007 3:36 am

There are no duplicates in a hashed file. The hashed file has a primary key. By definition, the key to a hashed file - the Primary Key - is unique. A primary key is unique in every database of which I am aware.

What are you trying to accomplish?

chulett · Post by **chulett** » Wed Jan 31, 2007 7:24 am

Besides the fact that (as noted) hashed files have no 'duplicate' records, it can't be used to return multiples. Other stages can - UV, ODBC. What exactly do you need to do?