could you please provide more info on whether it is on a single listener event only need to process all 1 million records at a time. Do you want to rollback all the transactions even if 1 transaction fails?
Posted: 3 years ago
Posted: 3 Dec 2018 0:08 EST
krishna chaitanya Tirunagaru (tiruk)
Application Architect, Foundations & Emerging Solutions
Ideally we are trying to commit for every 100 records, so for eg: if 1010 record is failed we will roll back only 10 records, next time will reading the records again it will read all the first 1000 records, so this is my problem.. how to skip the records that are already processed (we can check for duplicate but dont want to do this for all the million records if the failure is some where near 5 lakh record )