The previous section describes how to cache data. This section describes approaches to use the caching in smarter ways.
Although it is useful to use a single dataset for both ETL and reporting purposes, it is often advisable to split those two tasks into two separate datasets.
In this scenario, you create one ETL dataset which loads the data from a source and saves the data in an SQL database. This is achieved using the Specify Datamart and DataMart table name fields on the cache tab.
A second dataset is created on top of the data in this datamarted table for dashboards and reports.
This way you can prevent the source data being accessed except during a caching window you specify.