Q&A BY TAG 'associations'

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

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

joins Associations Derived views

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

Associations

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

Association Associations

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

left join Associations

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

associations Association

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 Association

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

associations

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

associations Execution plans

"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

associations