We are having a reporting table which takes around 5 mins to refresh (runs every hour). We are facing issue when users run reports when the refresh is in progress and a blank data is reported. Please suggest possible solutions to handle this scenario.
Am aware of the table swapping technique.
Is there any other techniques to get this sorted out. Any links to such online material is also much appreciated.
Found some related arcticles at the below link:
If anyone comes across any other solution as this one. Please do post here.