I enabled Full Cache over a view and cached the data. Now, when I execute the cached view, the data of the view is always retrieved from the cache database instead of from the source. In case if I want to retrieve latest data from the underlying data source which is not cached when I refresh my cached view. There is an Incremental option under Full cache mode which is only supported for views that meets the '[Requirements a View Has to Meet to Support Incremental Queries](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/cache_module/cache_modes/incremental_mode#requirements-a-view-has-to-meet-to-support-incremental-queries)' section in the Incremental Mode of Virtual DataPort Administration Guide.
Reading your description, I believe that you do not have any field to indicate when the data was last updated, in that case, only full cache with periodic refresh would be best choice.
For more details, you can refer to [Full Mode](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/cache_module/cache_modes/full_mode#full-mode) section of the Virtual DataPort Administration Guide.
Hope this helps!