DSXchange

I am creating a Parallel job using Change Capture Stage. SQL Server(source stage), Oracle (target stage)
I like change capture to do a insert when there is a insert(working)
update when there is a delete (not working)
update when there is a update(working)
Please let me know how I can achieve this.

First step would be to re-post your question in the correct forum. For PX questions, that would be the Enterprise Edition forum. This one is for TX questions, a completely different product.

'update when there is a delete'

Change capture performs delete when there is a delete ideally. It does what it is supposed to do.

Alternatively, you can validate the value of change_code=2(Delete) in filter/transformer stage after change capture and can perform the update operation.

[sigh]

There is no Change Capture stage in WebSphere Transformation Extender (formerly known as DataStage TX). If you post in the correct forum, you might receive more cogent answers.

If you post the same question in multiple fora, you will get exasperated answers from regular posters, who reasonably consider that such behaviour wastes their time.