Bulk TT resolve and Bulk TT association has become basic requirement due to huge number of TTs. We have customised form level changes to accommodate(250 TT at time) but challenge in keeping performance of the system and allow bulk closure and bulk association.
We need expert advice from DB and Application perspective to support bulk resolve or bulk association (approx. 1000 at time) without impacting performance of the system.
I understand we can Mass Resolve using the Closure codes in Excel sheet and loading to SM using Text Import Wizard, please confirm if this is a feasible method and what is the performance impact in this approach?
Or do you suggest using a CIt Scenario to automate this task by running as a schedule.