Change Apply & Change Capture stages

[sri1dhar]

Hi,

I am designing a parallel job (Parallel Extender), the functionality of which needs to be:
A is the source table, B is the target table.
Compare data in table A and B, capture changes (insert/update, delete) and apply changes to B. After the job execution is complete
data in B needs to resemble data in A.
Following is a depiction of my job design:

A (after) --> ChgCapture --> changes --> ChgApply --> B
B (before)--> -------(blank)----------- B-->
Sorry. Don't know how to attach pictures.

The job works until capturing Changes. Applying changes to Table B is where I had problem. From the documentations it seems like the only thing that Change Apply stage does is insert records. It doesn't update or delete records from Table B. This means after applying changes Table B will not resemble Table A.

My question is, is this the right procedure? Can Change Apply Stage be used in this case or should I just capture the changes using Change Capture and write my own transform for insert/update & deletes on table using the change code.
If Change Apply can be used in this scenario, what is the right process?

Any help is appreciated.[/img]