Schedule Update - Refresh Frequency
We have a dashboard scheduled to be refreshed every day. Currently, we start loading at 11:30 AM in the morning and unload at 11:15 AM in the next day. This means that there is a downtime of 15 mins.
- Is it necessary to have downtime of data? (By downtime I mean that the report is not scheduled and if any user opens the report at that time he will have to fetch data from DB)
- What is the minimum downtime I can ensure?