Q&A

How to achieve JSON custom format for array of values while applying Denodo nest()
answered 11-01-2019 05:21:35 -0500

Hi Denodo Team, I have created a base view with 3 employee records for Dept_id= 'D100' as below. SELECT 'D100' AS dept_id , 'E1' AS empid FROM DUAL UNION SELECT 'D100' AS dept_id , 'E2' AS empid FROM DUAL UNION SELECT 'D100' AS dept_id , 'E3' AS empid...

Answers: 1

Nested Array DENODO JSON REST Webservice

How to do error handling on accessing data sources that we do not control + Different REST Web Service formats don't seem to return the same information?
answered 10-01-2019 10:31:48 -0500

Hello! There are two problems, that my team was wondering if there were answers to. The first problem: There are several data sources that we have no control over, and therefore can't tell if those services are live or not. My team was wondering how w...

Answers: 2

denodo platform XML Denodo Testing Tool REST Webservice json HTML Error Handling

How are the Surrogate key Field values maintained in Denodo
answered 10-01-2019 07:44:55 -0500

This is an interesting document on the approach for performing Type 2 SCD in Denodo. Can you help me understand the following. In the StarSchema on the web page aach dimension has an SK field. I am assuming these are Surrogate Key fields. How are the S...

Answers: 1
Related to: How to model slowly changing dimensions in Denodo

Surrogate key

Any guidance on keeping base-views from impala data sources "fresh"
answered 10-01-2019 07:42:06 -0500

Hello, Impala data sources cache data. Occasionally, we encounter views which fail due to an error that essentially says, the cache is out of date. If we execute "invalidate metadata" in impala, the error goes away. How do people automate this? Sche...

Answers: 1

Scheduler export
answered 10-01-2019 06:46:14 -0500

What can be the possible causes for an unexpected error while trying to export the jobs from the scheduler? Recently when i tried to export the jobs, i received an unexpected error notification.

Answers: 1

Denodo Scheduler 6.0

Brief Details about denodo
answered 10-01-2019 04:59:56 -0500

HI Team, Can you provide answers for below. Is denodo a client - server architecture Number of servers required to set up denodo Does it has data lineage? what does global search web service mean in denodo data govenance? Thank You!!

Answers: 1

launch a denodo job from the command line
answered 10-01-2019 02:03:37 -0500

Hallo Denodo Team, Our customer requires that we schedule Denodo Jobs (VDPCache) using an external tool (IBM TWS). I understand, from the documentation and the knowledge base (where I found a question about Tidal) that in order to do this we should op...

Answers: 1

scheduler command line job

Java Heap Error export vql
answered 10-01-2019 00:38:02 -0500

Hi I am getting following error while exporting vql from VDP , what could be the reason ? java.lang.OutOfMemoryError: Java heap space

Answers: 1

Json format issue while accessing through REST webservice with SQL having Double Quotes(") character
answered 09-01-2019 23:11:17 -0500

Here are the steps we tried and we are hitting with JSON format issue in output while accessing REST webservice on Denodo derived view. Can anybody help suggesting on how to get rid of backslash \ character in the output? We are looking for output to...

Answers: 3

JSON REST Webservice

Cascading drop downs in SSRS - Does Denodo work as a source for an SSRS Report with > 1 parameter
answered 09-01-2019 04:57:38 -0500

Hello, A common use case in SSRS is to build reports with a complex set of parameters with interdependencies. These interdependencies are used to progressively narrow the dataset returned to the user. Obviously, this requires definition of > 1 par...

Answers: 1