Delete large amount of data using Informatica

Hello,

Maybe someone have had a similar issue, did not manage to find in here.

We are using Siebel Loyalty and Informatica. We need to delete old transactions, but S_LOY_TXN has more than 220 million records.

The basic request is to delete all transactions older than 2 years. In DB it would be something like this:

DELETE FROM S_LOY_TXN

WHERE TXN_DT > CURRENT_TIMESTAMP - 730

;

Record count older than 2 years is about 100 million. I tried to use Informatica to delete records by  creating a workflow with Commit Interval 100k, still this would take a lot of time to delete records.