Queries on creating relationship between tables | Community
Skip to main content
maheswarik23685
Level 3
July 31, 2018
Solved

Queries on creating relationship between tables

  • July 31, 2018
  • 1 reply
  • 1948 views

Hi All,

Below is the code of 1:N relationship between 2 tables

<element label="Dealers" name="dealer" revLink="vehicleLink" target="all:dealer"  type="link">

      <join xpath-dst="@vin" xpath-src="@dealerId"/>

  </element>

1.In the above code @vin,@dealerId are not any key they are just attributes from two different tables. Can relationship can be done using attributes instead of PK in <join> ?

2. all:dealer is a custom schema created for global market. For mexico market we have extended all:dealer with nmx namespace.When creating relationship between vehicle links and dealer  tables in target which schema should I mention all:dealer or nmx:dealer ?

3 .all:dealer has autopk. In the extension schema nmx:dealer can we create a custom attribute "dealerId" as primary key. In this case what will be the impact if the table all:dealer has two primary key(autopk "id" and dealerId as custom PK) .Is it a good practice to have custom primary key for extension schema .Will this have any impact on all:dealer  table

Thanks,

Maheswari

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by pablo_rosero1

Hi Maheswari,

This should help: Links Between Tables in Adobe Campaign Classic |

All the best,

Pablo

1 reply

pablo_rosero1
pablo_rosero1Accepted solution
Level 9
November 27, 2018

Hi Maheswari,

This should help: Links Between Tables in Adobe Campaign Classic |

All the best,

Pablo