Home » Developer & Programmer » Data Integration » Mappings in OWB and update problems.
Mappings in OWB and update problems. [message #93399] Fri, 12 November 2004 03:15 Go to next message
Karl Johan
Messages: 5
Registered: September 2004
Junior Member
Hi.

I have two tabels in two different schemas. Lets call them A (source) and B (target). The tables are similar. The rows in the A table can be updated, deleted, inserted.

It works fine with the insert. It come over to the B table.

For update on A. Nothing happend in B. It should be updated.

Delete in A. Shall not influence on table B. It works.

Is there anybody who know how to make the Update possible when i execute the module in OWB?

Thanks

 

Report message to a moderator

Re: Mappings in OWB and update problems. [message #93461 is a reply to message #93399] Fri, 04 February 2005 00:00 Go to previous message
Raju
Messages: 74
Registered: March 1999
Member
use update/insert load Strategy for target table properties.

Report message to a moderator

Previous Topic: Exceution of the OWB Mapping in Debug Mode.
Next Topic: check for null in SQL*Loader DEFAULTIF clause
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 04:39:43 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.