How to peorfrm insert and update using merge stage?

jvravi · Post by **jvravi** » Thu Nov 29, 2007 2:10 am

Hi,

I want to merge two tables. If i find any matching records then i need to update that records else i need to insert that record.

Could you help me how to acheive this using Merge stage

ray.wurlod · Post by **ray.wurlod** » Thu Nov 29, 2007 2:50 am

Is this a server job question (you posted in the server edition forum) or a parallel job question (you marked the job type as parallel)? Merge stage in the two different editions performs radically different tasks. Why are you insisting particularly on the Merge stage anyway? It's almost certainly not the correct stage type to choose in either edition.

chulett · Post by **chulett** » Thu Nov 29, 2007 7:49 am

Not a job for the Merge stage, all you need is 'normal' lookup logic to determine inserts versus updates.