Q&A BY TAG 'denodo'

You must sign in to ask a question. If you do not have an account, you can register here

Scheduler: Delay till the data gets loaded in actual databases
answered 27-06-2017 12:36:19 -0400

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...

Answers: 2

cache DENODO denodo scheduler SQL Server

Scheduler: Truncate cache tables instead of invalidating.
answered 23-06-2017 09:17:54 -0400

I have a scheduled VDPCache job which starts every Saturday at 12:00. It invalidates the data for All Rows and load the cache every weekend . This makes the Cache Database keep a lot of invalidated data which is of no use and the disk space consumption...

Answers: 1

DENODO denodo scheduler SQL Server invalidate cache

Incremental Caching
answered 15-06-2017 06:16:36 -0400

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...

Answers: 1

cache DENODO denodo scheduler

Date difference in hour
answered 09-06-2017 05:45:29 -0400

hi, I was wondering how to get hours difference between 2 dates in denodo? It seems like we just have 'getdaysbetween' function. Say, I have a start date of 6/8/2017 8:00:00 and end date of 6/8/2017 9:00:00. Now, I want to get 1 hour that elapsed betwe...

Answers: 1

DENODO

Creating a field in derived view using something like partition by.
answered 08-06-2017 09:02:58 -0400

I was wondering if I could get some help in terms of calculating a difference between the date of various statuses. I have a view with column named "id", "create_dt" and "status". I would have various statuses like submit, approve, deliver etc. Now, I ...

Answers: 2

DENODO

Cached data getting deleted as soon as it is done caching in SQL database
answered 06-06-2017 06:41:25 -0400

Hello, I am trying to cache the data using scheduler. There are around 30 views to be cached. 23 of them are having less data (around 10000 all together) and 7 of them are having heavy data (around 80000000 rows all together). So I created two VDPCach...

Answers: 1

Scheduler DENODO denodo scheduler SQL Server

Denodo installation steps on mac os
answered 02-06-2017 06:46:27 -0400

Hello everyone, I am absolutely new to denodo tool. I would really appreciate if someone can guide me through simple steps to install denodo on mac. My current mac os version is Mac Sierra 10.12.5 and java version is 8. Please help. I just need to get...

Answers: 1

DENODO MAC os new installation

intellisense not workin
answered 16-05-2017 13:22:38 -0400

Hi, I am new to Denodo and was wondering how intellisense functionality works on Denodo. When writing case statement, the intellisense comes up and once I select the statement and go on to fill in the logic for columns, there is no intellisense. Do I h...

Answers: 2

DENODO

JSON parameter with OR condition
answered 08-05-2017 06:16:48 -0400

Team, We are creating datasource going into Datasource -> Json and creating datasource connection and creating base view from API 1) We are succesfully able to create Datasource the connection passing below credentials DATA route: HTTP Client HTTP...

Answers: 1

DENODO json JSON

Access Cognos TM1 from Denodo
answered 28-04-2017 07:28:02 -0400

HI We wanted to Access Cognos TM1 from Denodo.INstalled the denodo O data wrapper in denodo What all details required to make successful connection to TM1 but not sure on options to select while creating a Datasource .Any document or link supporting it

Answers: 1

Denodo TM1