How can i setup a simple UPDATE in a mapping ???

UPDATE target
SET col1 = col2 + col3 * 0.01

Here is de Demo.

Of here is the note :

  • In the target table property set the loading type to update.
  • You must set the col1 properties with : Load Column when Update to Yes
  • You must set the col2 and col3 properties with Load Column when Update to Yes
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at del.icio.us
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at Digg
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at Ask
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at Google
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at StumbleUpon
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at Technorati
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at Live Bookmarks
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at Yahoo! Myweb
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at Facebook
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at Yahoo! Bookmarks
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at Twitter
  • Bookmark "How can i setup a simple UPDATE in a mapping ???" at myAOL
 
owb/how_to_do_an_update.txt · Last modified: 2008/12/05 10:50 (external edit)