DSXchange

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

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.

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