Queries on creating relationship between tables | Community
Skip to main content
maheswarik23685
Level 3
Jul 31, 2018 4:32 AM UTC
Solved

Queries on creating relationship between tables

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.
pablo_rosero1
pablo_rosero1Accepted solution
Level 9
Nov 27, 2018 1:10 AM UTC

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
Nov 27, 2018 1:10 AM UTC

Hi Maheswari,

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

All the best,

Pablo

Translate