Q&A

Denodo scheduler dependencies
answered 07-08-2020 13:00:08 -0400

Hi, We are facing the below problem in setting the dependencies in denodo scheduler. Sequence of job - 1.filecheck job - say JOB1 2.JOB2 3.JOB3 4.JOB4 5.Backup job - say JOB 5 Scenario 1: JOB 1 - dont have any dependencies and it should execute at trig...

Answers: 3

Connecting to Postgresql on EC2 Instance
answered 07-08-2020 11:59:40 -0400

Hi, I am trying to connect to a database "user" on a PostgresQL I set up on an EC2 instance. I believe I have allowed port 5432 on the inbound rules and I have modified the two config files. But I received this error message. Unable to establish c...

Answers: 2

PostgreSQL EC2 instance AWS

Multivalued variables from a query in %CONTEXT directive
answered 07-08-2020 09:40:37 -0400

Hi, is there a way to retrieve multivalued variables from a query in the %CONTEXT directive ? For example, I want to compare the count between views in Denodo and their datasources in DB2 : %CONTEXT viewnames[] = a, b, c schemavdp = eicorea schemadb2 ...

Answers: 1

Incremental data load in Denodo
answered 07-08-2020 08:39:58 -0400

How does Denodo ensure incremental load to a database while writing data ? Is it possible to create SCD type 2 using Denodo ? SCD : Slowly Changing Dimensions

Answers: 1

#Incremental Data Load

Checking for corrupt metadata
answered 07-08-2020 02:25:03 -0400

We have run into issues recently where one of our VDBs, or the entire dbmetadata database has become corrupt. Is there any type of checks than can be done to alert us when this happens for a faster response time?

Answers: 1

Free Trial: no extension available
answered 06-08-2020 07:10:30 -0400

Hi, I am second day on my free trial. I would like to connect to S3. However, there is nothing under "existing extension" Please advise. Thanks, Ming

Answers: 1

license custom S3 extension

About VCS Cache mode setup for views
answered 06-08-2020 06:05:57 -0400

Hi team Currently all of DV views are VCS by gitlab. I have a base view created, which is build on Oracle database. Now the views is under VSC by gitlab also, before we did not turn on the cache mode for this view, but when we put the cache mode to "Pa...

Answers: 1

cache mode view VCS

About VCS Statistics of views
answered 05-08-2020 17:35:10 -0400

Hi team Currently all of DV views are VCS by gitlab. I have a base view created, which is build on Oracle database. Now the views is under VSC bygitlab also, but it has no stastics gathering. So I gathered its statstics, and I also make the vql shown w...

Answers: 1

VCS gitlab view statistics

name the csv reports
answered 04-08-2020 18:14:14 -0400

Hi, using Denodo Testing Tool, I would like to have a distinct csv report for each .denodotest file, using the %NAME of the test for the name of the csv. for example if in my .denodotest file I have %NAME test1, i would like to have a report named test...

Answers: 1

Teradata to denodo sql
answered 04-08-2020 07:16:22 -0400

how to convert the below syntax from teradata to denodo sql (DATE-1 - DAYOFMONTH(DATE-1))+1 (DATE-1 - Extract(Day from DATE-1))+1

Answers: 1

date