Page 1 of 1

Using Changecapture stg/read&write the data in same tabl

Posted: Mon Apr 30, 2007 4:53 am
by Sridhar Sivakoti
Hi,

By using ChangeCapture stage can we read and write the data in same table in a job.

Please suggest me.

Regards
Sridhar

Posted: Mon Apr 30, 2007 5:27 am
by ray.wurlod
Not easily. The output from the Change Capture stage is intended to be used by the Change Apply stage. It would require further modification to be able to be used by other stages. You would also need to ensure that you do not introduce locking conflicts in that table.