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