Hi all,
i need to update existing records based on new incoming records.
i am taking existing records into hash file.
matching key columns are fund_name , fund_number.
Hi,
i am uisng look up with fund_name , fund_number. when i take existing records into hash file , i get only one record (with fund_name, fund_number).
so i am able to update one record .
my scenraio is there may be more than one record in existing database.
what is the solution to update other reords with (fund_name, fund_number)
Thanks
how to update multiple existing records based on New record
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Hi sainath,
Thanks for ur reply.
i am trying to develop with Merge Stage, that is the reason i have posted
i don't have other key column in table other than those two fund_name, fund_no.
is there any other way to solve this problem.
Thanks for ur reply.
i am trying to develop with Merge Stage, that is the reason i have posted
(recently in other post ),'job aborting in merging of two files'
i don't have other key column in table other than those two fund_name, fund_no.
is there any other way to solve this problem.
Sainath.Srinivasan wrote:You need to either include an additional col / attribute as key. Alternatively try to merge keys in a single row - which is not recommended.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A hashed file is based on a primary key lookup. A primary key equality constraint can only ever return one row.there may be more than one record in existing database
You may need two separate lookups against the same hashed file, if you have two different fund identifiers.
Otherwise, the Hashed File stage is not the appropriate stage type for your lookup; you need a lookup against either the target table itself or against a copy of relevant columns from it pre-loaded into a UV table (for example) or database table.
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.