Search found 1 match

by FDM
Thu May 24, 2007 10:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using Oracle Merge inside Oracle Enterprise stage
Replies: 2
Views: 1238

Using Oracle Merge inside Oracle Enterprise stage

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.