Q&A BY TAG 'denodo'
Validating the Denodo Backups
answered
24-08-2017 03:38:11 -0400
Hi, We are taking denodo backup on daily basis. Will it be possible to vaidate the backup vql to make sure that we have a healthy backup. We want to carry this process on mothly basis. I don't find any way in admin guide to do same . for example: resto...
Answers:
3
Caching Service Views
answered
23-08-2017 08:29:10 -0400
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...
Answers:
1
How to compare two views in denodo
answered
16-08-2017 06:06:54 -0400
Hi, Is there any way in testing tool to compare the the values of two views and send a alert with the MISSING VALUES in case ther's a mismatch. I tried to use select from view 1 in execution directory and select from view 2 in result directory. It wo...
Answers:
1
Unable to cache some views
answered
14-08-2017 09:24:58 -0400
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 ...
Answers:
1
Alter on Base View - Add Trim
answered
10-08-2017 12:24:32 -0400
I would like to add Trim() function to the column in the base view to remove the default spaces for CHAR data type. Can I do this by running an alter statement? I need to do this across all the coulumn in the Source, Is there any setting to do trim by ...
Answers:
2
Keep view names to cached tables
answered
08-08-2017 09:11:08 -0400
When I am caching the views, some numbering is adding to the table names in the cache database. I want just the view names to be kept for the tables in the cache databse. Is this possible. If yes, please let me know how can I get this done. Thanks, Sa...
Answers:
1
Avoid deleting the cached data at the time of deployment to upper environments
answered
08-08-2017 09:09:02 -0400
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...
Answers:
1
Export Denodo Scheduler jobs for the backup
answered
28-07-2017 09:27:38 -0400
Hi, I'm trying to use the export script to export all the denodo jobs and wanted to schedule the script on weekly basis. But before that when i'm trying to use the export script it throws multiple errors: In Test environment: C:\Denodo Platform\Denodo...
Answers:
1
Denodo Monitor Service Not Maintaining Running Status
answered
14-07-2017 17:15:59 -0400
Hello, I just finished following this tutorial on two machines. The first machine worked flawlessly and is running well (my local dev machine). However, after performing this on the DEV server (running Windows Server 2012), I am experiencing issues k...
Answers:
2
Related to:
Denodo Monitor as a Windows service
Execution time increased after turning on the Cache
answered
13-07-2017 04:25:58 -0400
I am having around 20 services created whose base views are cached and indexed. The performance(execution time) of all the services was improved when I switched to cache database except one service. This one service execution time is increased to more ...
Answers:
1