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
Multiple reference records from hash file
Moderators: chulett, rschirm, roy
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 wrote:Yes, in the Database group. If you don't find it there, you can add it (Customize)rejith.ry wrote:
Is the UV stage available in server jobs? If yes, in which paltte?
Rejith R
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.