You can translate the question and the replies:

Incremental Refresh of Summary View

I have a senario where I want to refresh the content of Summary view incrementally. How best I can achieve this by using Denodo Scheduler or other means? In the arcticle, it is mentioned that for CACHE, you have this variable which tracks out when was the last time, it refreshed the content of it with this clause ' Column > '@LASTCACHEREFRESH'. I have a datetime column available in the dataset but how i can achive the incremental refresh of summary
02-08-2023 09:29:20 -0400

1 Answer

Hi, I would use 'Create OR Replace' command for summary table and use datetime colum available in dataset to insert the rows that are not available in the summary. Below is an example query. Example > CREATE OR REPLACE SUMMARY VIEW my_summary > INTO sqlserver_data_source > CATALOG = 'master' > SCHEMA = 'dbo' > AS SELECT * FROM vdp_view WHERE id > 100; Please refer to [Summaries]( section of Virtal Data Port VQL gude to know more. Hope this helps!
Denodo Team
25-08-2023 06:39:48 -0400
You must sign in to add an answer. If you do not have an account, you can register here