Page 1 of 1
Using Oracle Merge inside Oracle Enterprise stage
Posted: Thu May 24, 2007 10:16 am
by FDM
Can we actually use an Oracle "MERGE" sql inside an Oracle Enterprise stage? If not, what is the most efficient way to accomplish this function in Datastage? Ie, using sqlldr(Load), upsert, etc?
Thank you.
Posted: Thu May 24, 2007 3:25 pm
by ray.wurlod
Welcome aboard. :D
Via "user defined SQL" you can execute any SQL that is legal in the database, provided that the correct number of columns is bound to the query.
Posted: Sun May 27, 2007 3:34 am
by ivannavi
We use this a lot. A dummy link on the left side (either from the row generator or "select dummy from dual") which triggers the right side declared as "user defined update only" which contains the merge statement. The downside is you don't get to see number of rows processed.
Ray, is there any better solution to this?