Q&A BY TAG 'Derived views'
Building derived views that originally have subqueries in them
answered
16-02-2021 10:07:04 -0500
I have a query that I'm trying to build the logic for as a derived view. Basically, translating my view that is on a DB to Denodo as a Derived View. Trying to figure out that if we have a subquery in the from or where clause, do we have to create anoth...
Answers:
2
Joinin view from different data source
answered
18-11-2020 07:37:05 -0500
I have created 2 views from 2 different folder of same parent folder. Suppose parent folder name is Parent and it has 2 subfolder like subfolder1 & subfolder 2 I have created derived view by joining both views.Now challenge is when I am trying to ...
Answers:
1
Joins in Derived Views (VS) Associations
answered
21-10-2020 07:57:58 -0400
Hello Team, I would like to understand what option is better to use in the scenario of star schemas: Only Joins in models for the derived views Only Associations in Derived views A combination of Joins and Association in Derived Views Plea...
Answers:
1
Need to extract the second row of a duplicate in a table
answered
20-10-2020 08:03:34 -0400
Hi Folks! I have a scenario where I have a list of customers with a driver number. In some instances, the customer is duplicated because of a second driver being assigned to the customer. Such as this; Customer Driver 101369 5058 101369 5602 How do ...
Answers:
1
About Access to view vql of derived views
answered
24-04-2020 13:35:51 -0400
Some one of my team wants to exexcute one derived views that I created, and he also wants to have the read access of that derived views's vql. I grant "metedata", "execute" access of this derived view to him, I think it is the read access we mentione...
Answers:
1