Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UPDATE/INSERT

508601Sep 25 2006 — edited Oct 4 2006
Hello Everyone,

I am trying to do a simple update/insert into an OWB table. Initially my table is empty and there are 6 records coming in with the same unique key. Only one should be inserted and the rest should be updates. I have a straight mapping loading directly from source to target.
I set my loading type to update/insert matching by my uinque key constraint.
and I linked the source columns to the target columns.

OWB is giving me this warning:
''Merge statement cannot be generated because column xyz is used for both matching and update. A matching column cannot be updated in a merge statement.''

What am I doing wrong and how do I solve this.

Your help is greatly appreciated.
Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2006
Added on Sep 25 2006
28 comments
1,674 views