Latest Activity

code

Joins in Derived Views (VS) Associations

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...

joins Associations Derived views

code

How can I verify if Denodo is really using Association for my query

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 ...

Associations

code

Traverse links at associations

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?

Related to: Associations in Denodo

Association Associations

code

For left join, do we need to create associations to remove not required Join

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...

left join Associations

code

On which level should i place my associations

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...

Related to: Associations in Denodo

associations Association

code

Query regd. Associations

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.

associations Association

code

Associations not carrying over to derived view from base views?

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.

associations

code

How associations help to choose best execution plan?

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...

associations Execution plans

code

"Ghost " associations

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...

associations