Queries on creating relationship between tables

Avatar

Avatar

maheswarik23685

Avatar

maheswarik23685

maheswarik23685

30-07-2018

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

pablo_rosero1

Avatar

pablo_rosero1

pablo_rosero1

26-11-2018

Hi Maheswari,

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

All the best,

Pablo

Answers (0)