Q&A BY TAG 'derived view'
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
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
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
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
Derived view access issue from Alteryx
answered
13-07-2017 09:06:23 -0400
Hi, User wanted to connect to a derived view from Alteryx, So I have provided connect privilege for the respective database and read privilege to the derived view. Now the user is able to access the derived view from SQL editor in Alteryx but not able...
Answers:
1
restricting access to derived views only.
answered
10-07-2017 17:16:11 -0400
Can we provide read access for a derived view to users without providing any access to base views. User is accessing views from another tool(Alteryx) through odbc connection. Thank you Sachi
Answers:
2
Creating a new column in derived view
answered
12-04-2017 08:49:20 -0400
Hi team, I created a derived view from two base views. In this derived view I want to create a new column doing the following transformations to the data: I currently have this column existing column street: value: 'streetname123' I want to create a...
Answers:
1
Field expressions guide
answered
30-03-2017 06:53:24 -0400
I'm trying to find a good guide on writing field expressions for new fields in derived views. I've looked through the admin, developer and advanced VQL guide and still can't find what I'm looking for. What I basically want to do is create a new field ...
Answers:
4
View Parameters and Aggregation
answered
02-03-2017 08:54:39 -0500
I am fairly new to Denodo and I have read through the Advanced VQL and VDP Administration Guide but I am not able to resolve the following issue: Sample Base View For the sake of this issue, let's consider a base with student, months and rank. ...
Answers:
4