How to do a conditional delete on sequential file

[poornima.chandramouli]

I'm doing a CDC of a sequentila file with a dataset & capturing the records which is preset in the sequental file & not present in the dataset.
I've to delete these particular records in the sequential file,how to achieve this.

Thanks in Advance.

[ArndW]

You cannot delete single rows from a sequential file. You will need to copy the original file to another and skip the records that you don't want.

[keshav0307]

set the Sequential file as after dataset and dataset as before dataset link for Change Capture stage, and drop records for delete, update and insert, the output from this is what you need.