Q&A BY TAG 'joins'

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

Error using multiple inner joins
answered 19-01-2021 04:53:30 -0500

Hi Community I'm facing an error with vdp, when using joins. I'm working on a view using 28 inner joins, at 25th join everything works fine, but when i add the 26th table to join with i have the following error : Finished with error: Error executing...

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

joins Associations Derived views

Simulating an Update statement in Denodo
answered 18-08-2020 03:14:45 -0400

How do we simulate below statement in a derived view in Denodo update fw_denodo_table a set a.column1 = b.column2 from denodo_table2 b where a.column2 = b.column3 and a.column5 = b.column6 and a.year=2019; Please advise

Answers: 1

joins update derived view