You can translate the question and the replies:

when we have to use the Incremental update based on PK

Related to: Incremental Queries in Denodo
when we implement the Incremental cache , we shold provide the condition at base view (lastmodified_date>Last_cache_Refresh_Date) and i am clear with it ,but what should be used for the property "Invaliate the cache Before Load" in scheduler load process should it be 'None', 'All Rows', or "Matching_Rows" or 'Incremental Update Based on Primary Key'? Also Should we have to provide the field for the Property "Latest modification date field for incremental updates"? Please suggest. Thanks, Sagar Bazar
incremental cache Queries
user
15-02-2023 05:45:57 -0500
code

1 Answer

Hi, When selecting the property ‘Invalidate the cache before load' there are some things to take into consideration such as data being deleted, data being added, etc. If the data is constantly changing in every row you may need to select ‘All Rows’. For the property ‘Latest modification date field for incremental updates’, if you need to know when the last time the query was refreshed then it would be best to include it. You can refer to [VDPCache Extraction Section](https://community.denodo.com/docs/html/browse/latest/en/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/vdpcache_extraction_section) in the Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
22-02-2023 18:42:19 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here