UPDATE/INSERT
508601Sep 25 2006 — edited Oct 4 2006Hello 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.