You can translate the question and the replies:

Data Movement & Cache

Hi , I have Denodo version 7.0.20181011. I have problems with the data movement and with the cache. once the cache is enabled on a DV everything runs correctly but the record is not in a validated state? how come? I also wanted to know if with the data movement it is possible to first define the name of the objects that denodo will create or will be random thank you
19-04-2022 05:35:15 -0400

1 Answer

Hi, I would ensure the existing cached data is invalidated before loading the data into the cache database. This would prevent duplicate or invalid data from being stored in the cache database such that the cached data is always accurate and up to date. You can refer to the Knowledge Base Article [Availability of full cache]( and section [Cache Invalidation]( of the VQL guide for more information on cache invalidation. Regarding your question on Data Movement object definition, it is not possible to manually define the structure at the moment as the Virtual DataPort automatically transfers the data of the smaller view into the data source of the larger view and executes the operation in the second data source and executes the operation in the second data source. As soon as the query execution is complete, the object created during this process is deleted. You can refer to the [Data Movement]( section of the Virtual DataPort Administration Guide which elaborates on the behavior of the Data Movement optimization mechanism. Hope this helps!
Denodo Team
 Edited on: 20-04-2022 08:43:24 -0400
You must sign in to add an answer. If you do not have an account, you can register here