Multiple reference records from hash file

rejith.ry · Post by **rejith.ry** » Wed Jan 31, 2007 12:24 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

narasimha · Post by **narasimha** » Wed Jan 31, 2007 12:34 am

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.

rejith.ry · Post by **rejith.ry** » Wed Jan 31, 2007 12:41 am

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?

narasimha · Post by **narasimha** » Wed Jan 31, 2007 12:51 am

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)

rejith.ry · Post by **rejith.ry** » Wed Jan 31, 2007 12:57 am

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?

narasimha · Post by **narasimha** » Wed Jan 31, 2007 1:01 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Jan 31, 2007 1:02 am

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).

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

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.