Latest Activity

code

Triger cache load job when no records

Hi, Is it possible to trigger a cache load query for a view whenever the count for the view doesn't gives any record. Basically i want to run a count on the view and when it doesn't give any record a cache load should happen.

cache VDP

code

Caching Service Views

There are 14 Service Views in my database which gives data from 2011 - 2018 (joining different combinedviews). We created partial service views for each of the service view by giving a where condition inside the Partial service view (less than 2016 and...

cache DENODO Denodo Scheduler 6.0 SQL Server

code

Unable to cache some views

I am trying to cache on Service Views Layer (14 Service Views). In the scheduler, I created VDPCahce jobs for every individual service view. After starting those jobs, I started the monitoring tool to see the status of caching. After 3 hours, 6 of the ...

cache DENODO denodo scheduler SQL Server

code

Avoid deleting the cached data at the time of deployment to upper environments

We have some views created in the local environment and when we deploy it the upper environment, we cache the views. So, every time we do a deployment we turn the cache back on all the views. This is making the tables which are cached previously in the...

cache DENODO SQL Server deploy

code

Partial Cache- Explicit loads

Denodo 6.0 express edition Created a derived view coming from a soap web service and a mysql database. Enabled cache at the server level. Enabled partial cache with explicit loads for the derived view. I executed the query "Select * from derived_view_...

cache Partial cache cache configuration explicit loads

code

Scheduler: Delay till the data gets loaded in actual databases

I have a scheduled VDPCache job which starts every Saturday at 12:00. The actual databases from where the cache data gets loaded will undergo a weekend processing and gets new data. Sometimes this processing will takes long time than expected. If I kee...

cache DENODO denodo scheduler SQL Server

code

Incremental Caching

Hello, I am in a situation where I am currently caching on the combined views layer. When I am done caching using Full mode for all the combined views for the first time, I want to keep the scheduled VDPCache jobs every weekend which must do increm...

cache DENODO denodo scheduler

code

Caching not working while joining two tables.

Hi, I have created two tables X, Y and enables the cache. With the current configuration. X, Y caching works individually. But when I do a join query with both tables. The cache is not working. Can some one help me on this. EX: select from X trace; -...

cache cache configuration Cache error

code

Teradata as Cache Database and Configuring Monitoring Tool for Teradata

Teradata as cache Database: Does Denodo supports Teradata as caching database ? If yes then is it works as other RDBMS system does ? I wanted to confirm if I setup Teradata as cache database, element delegation such as function, subquery, etc, should w...

cache cache configuration Denodo Monitor teradata monitoring tool monitor

code

Test file to check if cached view is not empty

Hi, I want to create a test files to see if the cached views are empty.Initialy i thought of just selecting top 100 records from cached view in %Execution directory and another query selecting top 100 directly from source in %result directive. But late...

cache Denodo Testing Tool cache configuration