You can translate the question and the replies:

Type of model in the join

The Denodo tool has the join function that allows you to join or integrate data from different sources, however, this works by means of PK (primary key) or FK (foreign keys), I would like to know what models are formed. In other words, it is a star model or a relationship entity model or another. I want to know specifically what model is created when we join the tables using the PK and FK.
user
20-01-2020 12:35:45 -0500

2 Answers

Hi, In Denodo Platform, you can use [join views](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_join_views/creating_join_views) to represent either an entity–relationship model or a star schema, depending on how you implement the join conditions. The ["Optimizing Join Operations"](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/optimizing_queries/optimizing_join_operations/optimizing_join_operations) section of the Virtual DataPort Administration Guide explains the different join execution methods supported by Virtual DataPort. If you are designing a star schema, it will be beneficial to create [associations](https://community.denodo.com/kb/view/document/Associations%20in%20Denodo?category=Combining+Data) between the fact table and dimension tables to establish PK-FK relationships and remove redundant joins, as was discussed in a [similar Community Q&A](https://community.denodo.com/answers/question/details?questionId=90670000000Xd0kAAC&title=All+joins+are+executed+when+creating+Star+Schema). For more information on associations, you can refer to the following sections of the Virtual DataPort Administration Guide: * ["Creating an Association"](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/restful_architecture/associations/creating_an_association) * ["Referential Integrity in Associations"](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/restful_architecture/associations/referential_integrity_in_associations) Hope this helps!
Denodo Team
21-01-2020 19:20:43 -0500
Thank you very much.
user
23-01-2020 17:01:27 -0500
You must sign in to add an answer. If you do not have an account, you can register here