DSXchange

How to get the number of records deleted from a table. I am using an oracle_OCI stage and a dummy file. Is there any way to capture the number of records deleted?(In select query we can get the link counts) Any help regarding this will be appreciated.

Hi,

Here one thing you can do, in your design is capture the all rows in a sequential file or Dataset before you delete records in DB.

Another option is ROLLBACK your databse to get your records, based on your commit interval.

Count the table before and after the deletion. The difference will be the number of rows deleted.

Or may be do a count(*) soon after deleting the data (provided u knew the count before deleting)...