This discussion is archived
1 Reply Latest reply: Sep 10, 2012 8:39 AM by David Allan RSS

merge in OWB

user409028 Newbie
Currently Being Moderated
Hi

in my present scenirio i have to insert the record if the matching value doesn't exist and update and add the vlaue to the already value for matching data.

eg mod_typ qty
A 5
B 8

TARGET TABLE (WHEN loade first time)
mod_type qty_1
A 5
B 8

new record in source and 1 for update

eg mod_typ qty
C 3--------------------should be inserted
B 2--------------------it should be added to value b

How can i achive , please help
  • 1. Re: merge in OWB
    David Allan Guru
    Currently Being Moderated
    Each attribute on the target when you are loading has a property (Update: Operation under Loading Properties for the attribute) which determines the operation performed, by default it is = (an assignment), but there are others there such as += (add), -= (subtract), *= (multiple), /= (divide), ||= (concatenate) for example plus a bunch of combinations. This lets you do all sorts, so you can define the update operation property to be += for attribute QTY_1 in your target table operator.

    Cheers
    David

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points