Q&A BY TAG 'associations'
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
How can I verify if Denodo is really using Association for my query
answered
27-07-2020 08:29:13 -0400
Hi team - just want to check if Denodo's execution trace (or anything else) will show me an association if it gets used while executing a query (on the views on which this association is defined) ? How can I ensure that association is getting used for ...
Answers:
1
Traverse links at associations
answered
06-07-2020 16:23:15 -0400
hey, I saw at documentations that we can't traverse links execpt if primary key defined at view , but I create assocciation wihtout definig primary keys at views and I traversed links at resftful webservice , how that happen please?
Answers:
1
Related to:
Associations in Denodo
For left join, do we need to create associations to remove not required Join
answered
01-07-2020 15:45:57 -0400
Questions for Asssociation I have one view (v) creating by one fact table (Table F) left join several dimension tables (Table A, B, C, D), I define PK for the fact and all dimesion tables. I have not defined associats for them, when I ran this: "sele...
Answers:
2
On which level should i place my associations
answered
13-05-2020 17:46:42 -0400
Hello, On which layer would you advice to place the associations? Lets say i have 4 levels: connectivity layer (only connections + base views) Integration layer (simple combinations of base views) Business Entities layer Presentation layer...
Answers:
3
Related to:
Associations in Denodo
Query regd. Associations
answered
06-01-2020 15:24:58 -0500
Hi All, I had stuck with a case that when i hit the associations rest service to get the details, am getting only table names in response but not the mapping details between those tables.
Answers:
3
Associations not carrying over to derived view from base views?
answered
26-12-2018 10:33:53 -0500
When creating a derived view from base views that have associations, how come the new derived view does not have those associations? Have to recreate all of them.
Answers:
2
How associations help to choose best execution plan?
answered
12-03-2018 03:51:51 -0400
Hi there, One of the benefits mentioned in the introduction slide from the Linked Data Associations course (DEN60EDU0134) , mentioned that associations are useful because 'They will be used to optimize queries to increase performance by generating bett...
Answers:
1
"Ghost " associations
answered
31-01-2017 22:28:48 -0500
I created a fact view and a number of dimension views and the associations between them. I renamed the fact table ...... the associations disappeared. I thought Denodo would handle the renaming gracefully but it looked like the associations had been de...
Answers:
3