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

Sridhar Sivakoti · Post by **Sridhar Sivakoti** » Mon Apr 30, 2007 4:53 am

Hi,

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

Please suggest me.

Regards
Sridhar

ray.wurlod · Post by **ray.wurlod** » Mon Apr 30, 2007 5:27 am

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.