Change Capture Stage

RahulChandra · Post by **RahulChandra** » Mon Feb 22, 2010 4:27 pm

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.

chulett · Post by **chulett** » Mon Feb 22, 2010 5:50 pm

Define 'not working'. Be precise about what it is or isn't doing, please.

rohithmuthyala · Post by **rohithmuthyala** » Tue Feb 23, 2010 7:15 am

I'm assuming if you say "not working" , the delete records are not coming out of the Change Capture Stage.
If this is the case, inside the Change Capture Stage in the Stage Properties Tab please select the option as "FALSE" for Drop Output For Delete.