Hi,
I have been tasked with creating some reports, that will be viewed on a weekly basis, meaning the data for the reports only needs to be updated once a week.
Basically my question is, is my approach correct. I don't want to run queries against live data, so the idea is to create separate tables that will be populated during off-hours with the aggregated data. Then once the tables are populated, then run the queries against the pre-aggregaged data.
Are there any FAQ's that I can refer to, or does this sound about right.
Thanks
I have been tasked with creating some reports, that will be viewed on a weekly basis, meaning the data for the reports only needs to be updated once a week.
Basically my question is, is my approach correct. I don't want to run queries against live data, so the idea is to create separate tables that will be populated during off-hours with the aggregated data. Then once the tables are populated, then run the queries against the pre-aggregaged data.
Are there any FAQ's that I can refer to, or does this sound about right.
Thanks