DSXchange

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

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?

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?