Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Target has duplicate rows that need updating

Status
Not open for further replies.

spartacus13210

Programmer
Aug 16, 2006
3
US
hi all,
i have a mapping where i have a lookup trans. (against the target) and if a record is found (one that matches the source) i update the record in the target through an update strategy, router etc.

My question is: i have multiple rows in my target that contain the same field value that i am looking up against and i need to update all such rows in my target and not just one--which is what my mapping is doing!

Is there an option somewhere...that i can modify?

Thanks!
 
In a normal situation you would use the primary key of the target to design update/insert/delete strategies.

If you have multiple rows that qualify then how about the primary key? You should define one to work with updates..

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top