Q&A

Training DEN60EDU0118LAB01
answered 15-11-2019 06:39:32 -0500

In this lab, I don't know how to " Project the input parameter parameters.categoryname to convert it in a simple field, and rename it as input." It's the second sentence in the Excercise instructions below. Can someone provide detailed instrucitons? ...

Answers: 1

training

Get the VQL query using the java code
answered 14-11-2019 16:55:50 -0500

Hello Everyone, Please help me how can i get the vql query of join views through the java code.

Answers: 1

Getting obligatory field of views
answered 14-11-2019 16:50:41 -0500

Hi Team , Is there any metadata table or procedure of denodo by which we can see query capabilities ,in order to find which fields are mandatory and which are optional. Thanks.

Answers: 1

Metadata views

Get created view VQL query using JAVA code
answered 14-11-2019 16:48:45 -0500

Hello Everyone, Please help me how can i get the vql query of join views through the java code.

Answers: 1

DEN60EDU0118VID01 - Combination. Foundation
answered 14-11-2019 15:53:51 -0500

In this training video, the guy shows view parameters and I believe the lab requires a view parameter as well. And in my Administration Tool, the pencil next to 'View parameters' is not highlighted and when I hover over the pencil a message pops up......

Answers: 1

training

Dynamic query execution
answered 14-11-2019 12:10:40 -0500

Hi Team, I want to execute my query dynamicaly at runtime without creating stored procedure..How can we achieve this in denodo 6.0. Is denodo has any feature or inbuilt function just like 'EXECUTE IMMEDIATE' in oracle so that it implement the result ...

Answers: 1

Denodo 6.0

Getting following error while executing the view
answered 14-11-2019 07:19:40 -0500

Finished with error: Error executing query. Total time 0.545 seconds. P_P_P_RV_SAP_CASHFORECAST3_VENDOROPENITEMS [PROJECTION] [ERROR] P_P_RV_SAP_CASHFORECAST2_VENDOROPENITEMS [VIRTUAL] [ERROR] QUERY: SELECT * FROM p_p_p_rv_sap_cashforecast3_vendorop...

Answers: 1

Create BV with variable
answered 14-11-2019 06:04:52 -0500

Hello: I want to create a BV from a JDBC resource, and I have a csv, with some fields and I want to get the value of the variable from this CSV. the query is select name, address from people where country=@country and I have this CSV: L...

Answers: 1

Base view Interpolation Variables variable

how to use a interpolation variable in where condition of a derived view
answered 14-11-2019 04:46:49 -0500

Hi, I want to to pass a dynamic value as filter in where condition. I am try column1 =@input_value_for_column1 can you suggeset as why its not working, do we need to do anythign else to use interpolation variable or to pass the value dynamic in the w...

Answers: 3

Interpolation Variables

Query two data sources(May be sql server and DB2 ) using Denodo Testing tool.
answered 13-11-2019 13:04:34 -0500

Is it possible to query two different data sources Can i join them in one query and get output? without help of linked server how can i query two different data sources and get single output. Eg Sql and DB2 or salesforces Thank you for help!

Answers: 1

Denodo Testing Tool Database Data sources