You can translate the question and the replies:

Meaning of the join arrow's direction in a join view

When joining two or more views (as source) together in a join view, Denodo will draw an arrow between the tables. The arrow's direction seems to depend on how you "*draw*" the line, i.e. from which table you start. Is there any "*deeper*" meaning to this arrow? Does it have any consequences for the SQL generation? The only thing that we've found so far is that it will determine the order of the tables, therefore switching the arrow's direction could have an effect for a left/right outer join. Other than that…?
user
07-03-2018 07:57:52 -0500

1 Answer

Hi, When you create a JOIN view, Virtual DataPort Server creates simple JOIN condition by linking a field of one view with another view by default. You could change the JOIN condition based on your requirement. It does not have any consequences for the SQL generation. You can configure the JOIN type and JOIN strategy from available options like Inner, Left outer, Right outer and Full under the JOIN conditions of the view. For more information, you could refer the [Creating Join Views](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/creating_derived_views/creating_join_views#creating-join-views) section of Virtual DataPort Administration Guide. Hope this helps !!
Denodo Team
08-03-2018 08:11:48 -0500
You must sign in to add an answer. If you do not have an account, you can register here