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

Duplicates are always removed in the keys from a hashed file.(Destructive overwrite)
A hashed file lookup returns a single row.
You will have to use UV or ODBC stage to achieve your requirement.

narasimha wrote:Duplicates are always removed in the keys from a hashed file.(Destructive overwrite)
A hashed file lookup returns a single row.
You will have to use UV or ODBC stage to achieve your requirement.

Is the UV stage available in server jobs? If yes, in which paltte?

rejith.ry wrote:
Is the UV stage available in server jobs? If yes, in which paltte?

Yes, in the Database group. If you don't find it there, you can add it (Customize)

narasimha wrote:

rejith.ry wrote:
Is the UV stage available in server jobs? If yes, in which paltte?

Yes, in the Database group. If you don't find it there, you can add it (Customize)

I think UV can be used to connect to database only. My reference data is a flat file. So I am trying to use a hash file after the flat file. Can you suggest any workaround for this?

Check this link, a search can give you more results.

A Hashed File stage accesses a hashed file, which must have a primary key. Spend some time researching/learning.

A Hashed File stage can NOT be used to access a text file. You must use a Sequential File stage, Complex Flat File stage or Merge stage for that.

Please document (post) your job logic (and your job design, if you think that will help, but it's the job logic that's critical).

ray.wurlod wrote: A Hashed File stage accesses a hashed file, which must have a primary key. Spend some time researching/learning.

A Hashed File st ...

This question is moved to server forum.