I understand your scenario as, you have a view which is built on top of several views that are accessing the tables from the underlying data source(s) to fetch the data, when you execute the view/ or a query.
If you enable cache for your view(s) with necessary context clause, based on the cache mode enabled, the execution engine will decide whether to fetch the data from the source or the cache database. I think for your use case, [Incremental Mode](https://community.denodo.com/docs/html/browse/latest/vdp/administration/cache_module/cache_modes/incremental_mode) might help wherein queries will always return fully up to date results without needing to retrieve the full result set from the data source, just the rows that are added/changed since the last cache refresh.
If you are a valid support user, you can raise a case describing your use case with the VQL of the view and Execution trace attached and it will addressed better.
Hope this helps!