I would like to get an opinion on the best practices we should follow for failure scenarios in the orchestrations
For Example, I have 500 records to process from db to Salesforce with batch size as 200. Now lets say the activity in the orchestration fails at 450th record.(Maybe connectivity issue). So in this case the entire transaction will be rolled back and the 500 records will not be inserted/updated into Salesforce. So how could I trace this 500 records which were part of failed scenario? One possible solution I could think of is maintaining a separate table and push all the records to that table.
Is there any other general practice available to handle such type of scenarios?
Also please provide any links or tutorials if you have any on this topic.