Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Queries on creating relationship between tables

Avatar

Avatar
Validate 10
Level 3
maheswarik23685
Level 3

Likes

21 likes

Total Posts

32 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
maheswarik23685
Level 3

Likes

21 likes

Total Posts

32 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
maheswarik23685
Level 3

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
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

26-11-2018

Hi Maheswari,

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

All the best,

Pablo

Answers (0)