You can translate the question and the replies:

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?
user
06-07-2020 05:17:12 -0400
code

1 Answer

Hi, An association represents a relationship between two views and it is defined by two endpoints and a list of mappings where you can traverse them. You can traverse links even if the associations were created without defining primary keys for the views. In fact, any association that maps views together can be traversed. When you can mark the association as a Referential constraint and set a Role precondition, then the association is considered as the traditional primary key/foreign key constraint of relational databases. For that type of association, you would need to define primary keys which would help to define a better semantic model because you can define referential constraints (primary key/foreign key relation) between views. For more information, please refer to the [Associations](https://community.denodo.com/docs/html/browse/latest/vdp/administration/restful_architecture/associations/associations) section of Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
06-07-2020 16:23:15 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here