Q&A BY TAG 'derived view'

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

Delegate SQL Sentence as Sub Query not passing to source
answered 23-07-2019 01:57:09 -0400

Hi, I created base view from SQL stored ptocedures. Function have 2 mandatory parameter. When where clause for 2 mandatory field and on additinal field. then manadatory field is filtered by source. But additional field is filtered by Denodo. My Quest...

Answers: 1

subquery Execution plans Stored Procedure derived view

How to query on different View?
answered 17-07-2019 08:22:31 -0400

I have 3 derived view A, B and C. I want to pass parameter from web services like B then the query agains B derived view. If I pass C then the query agains C derived view. This is possible in Denodo ??

Answers: 3

REST Webservice derived view Interface

How to query on different View using web services?
answered 11-07-2019 06:21:13 -0400

I have one Base view top of that I am creating 3 diffrent logic Derived view A, B and C. I want to pass parameter from web services like B then the query agains B derived view. If I pass C then the query agains C derived view. This is possible in Denod...

Answers: 1

REST Webservice derived view Interface

How to deploy the derived view in the different environments (Staging/Production) from Development with updated fields without modifying the individual derived views?
answered 22-01-2019 16:09:34 -0500

I have created a "Selection" Derived View. I would like to add a field in the Derived View for "URL" in the final output for Tableau reports like "https://DevTableauServerName/DevReportname". So, I added like this, Output Tab -> New Field -> Fi...

Answers: 1

derived view URL deployment

issue in accessing derived views in Alteryx
answered 19-10-2018 16:17:06 -0400

Hi, I have provided access for a derived view from denodo to Alteryx. The user is able to access the derived view from SQL editor in Alteryx. My question here is Can I view the list of derived views in the rightside navigation panel in the Visual Que...

Answers: 2

access ODBC Alteryx derived view alteryx

How to create a parameterized derived view? Or Is there any way to access a subset of the data(base view) instead of accessing entire table(base view)?
answered 12-06-2018 12:50:33 -0400

I would like to create a derived view (one master base view will join with 3 code lookup base views). It has 5 millions records by Year (2002-2016). When I try to access this view from third party tool like Tableau, it is cripplingly slow and it timed ...

Answers: 1

Parameterize slow query Parameter Tableau derived view

Denodo Training - Derived Views
answered 17-04-2018 11:45:29 -0400

Hello, I am taking the Denodo Training and i am stuck creating a derived view. Data Virtualization Developer Introduction - DEN60EDU0118LAB01 I do not understand how to convert parameters into a simple field.

Answers: 2

training derived view

How to view execution history of a view
answered 07-09-2017 09:14:34 -0400

Hi, How to see the execution history of a base/derived view. I want to see the historical execution status of a view. the run time and the status of execution. Is there any way we can get the historical statistics of the views executed in denodo. S...

Answers: 1

derived view execuion history

Creating an XML output view using the existing base/derived Views
answered 01-09-2017 09:29:26 -0400

How to Create an XML output using derived view ? for example: I have 3 base view Party, Party Address, Party Related Party. I will need to create an XML output, which needs to be published as SOAP Service. the structure should as below. <PartyServi...

Answers: 1

XML DENODO XML Data Source derived view XML request to response

SQL queries ran on native Data source in VDP
answered 29-08-2017 10:30:36 -0400

Hello there, I just a few questions, I was wondering if you could provide me with an answer. How can I edit a SQL query that I created directly on the Data Source(Hadoop)? How should the SQL query be written, names the datasource, table, and fiel...

Answers: 1

base view Hadoop Sql performance derived view