Hi All,
,@isahore ,@AndreaBriceno,@ParthaSarathy
,@ParthaS ,@Craig_Thonis ,@Manoj_Kumar_ ,@Amine_Abedour ,@Marcel_Szimonisz,@DavidKangni
,@Amit_Kumar,@ShashankNigam02,@Ganesh5067, @Jonathon_wodnicki
Usage of integrity attribute in schema definition in Adobe Campaign Classic
Just want to understand what will happen if we use below integrity in schema link definition
1)integrity=normal
2)integrity=own
3)integrity=define
Can anyone please explain me this taking example of recipient and Transaction schema, what is the purpose of using integrity attribute in schema link definition and difference it makes
@Parvesh_Parmar ,@Denis_Bozonnet
Solved! Go to Solution.
Views
Replies
Total Likes
Hello @DishaSharma ,
Please find the definition of Integrity:
integrity (optional): referential integrity of the occurrence of the source table to the occurrence of the target table.
Possible values are:
Document URL: https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-r...
Example:
Imagine you have two tables: Order Confirmation and Recipient. You can set up a link between them using code within the Order Confirmation table.
<element label="Recipient" name="recipient" integrity = "normal" revIntegrity="own" revLink="order" target="nms:recipient" type="link">
<join xpath-dst="@id" xpath-src="@recipient-id"/>
</element>
1. Explanation:
2. Reverse Link:
Key Points:
Summary:
Hello @DishaSharma ,
Please find the definition of Integrity:
integrity (optional): referential integrity of the occurrence of the source table to the occurrence of the target table.
Possible values are:
Document URL: https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-r...
Example:
Imagine you have two tables: Order Confirmation and Recipient. You can set up a link between them using code within the Order Confirmation table.
<element label="Recipient" name="recipient" integrity = "normal" revIntegrity="own" revLink="order" target="nms:recipient" type="link">
<join xpath-dst="@id" xpath-src="@recipient-id"/>
</element>
1. Explanation:
2. Reverse Link:
Key Points:
Summary:
thank you for detailed explAined
I have couple of asks here based on what u mentioned:
1)the below code is written in Order Confirmation and u mentioned below code will create 1to 1 link
but my understanding says if we have to create 1to 1 linking we have to use 'revCardinality=single' in schema link definition no where I can see thAt
<element label="Recipient" name="recipient" integrity = "normal" revIntegrity="own" revLink="order" target="nms:recipient" type="link"> <join xpath-dst="@id" xpath-src="@recipient-id"/> </element>
how this code is creating 1to 1 link please help to explain
also want to und here please confirm
AS mentioned by you
"This code creates a 1-to-1 link from the Order Confirmation table to the Recipient table."
but link from Recipient table.to Order Confirmation table should be Many to 1(N to1)
how and where code is written to maintain for this
please help me to und this
2)I also want to understand as mentioned in post above what will happen if I use
a)integrity=normal
b)integrity=define
c)integrity=owncopy
considering an example of Recipient schema and Transaction schema are 1to Many(1 to N) linked
please please help
Views
Replies
Total Likes
Hello @DishaSharma ,
Please check the following points:
The order confirmation to recipient table will have a 1-to-1 link. This means that one order is linked with only one recipient.
The recipient to order confirmation will have a 1-to-N link. This implies that one recipient can be linked to multiple orders. For example, one recipient can place multiple orders.
If you want the recipient to order confirmation table link to also be 1-to-1 (which is currently 1-to-N as mentioned in point 2), then you need to use 'revCardinality=single'. This way, each recipient can be linked with only one order.
I would suggest conducting some tests in your sandbox environment with test data. Also, try other integrity to see the differences.
Regarding your second point, I have provided the definition in my initial comment.
Thank you,
Parvesh
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies