Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Difference between link and reconcilliation

Avatar

Level 6

Hi, in the reconcilliation box, we are adding links as well as reconcilling external data with DB data. Which one is similar to join operation? Reconcilliation or adding links? 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Sanjana12 ,

In the reconciliation tab of enrichment, you can reconcile with other schemas, but one to one link is possible.

If you want to join with other tables with other cardinalities like 1 to 0/1 or 1 to 1 or 1 to Many, you need to add as link in enrichment > add data > A link  >

ParthaSarathy_0-1698758884205.png

Whereas in Reconciliation tab, only 1 to 1 is possible.

ParthaSarathy_0-1698759874482.png

So depends on your use case, you need to decide.

 

For more information, Enrichment - Creating a link and Data reconciliation

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi @Sanjana12 ,

In the reconciliation tab of enrichment, you can reconcile with other schemas, but one to one link is possible.

If you want to join with other tables with other cardinalities like 1 to 0/1 or 1 to 1 or 1 to Many, you need to add as link in enrichment > add data > A link  >

ParthaSarathy_0-1698758884205.png

Whereas in Reconciliation tab, only 1 to 1 is possible.

ParthaSarathy_0-1698759874482.png

So depends on your use case, you need to decide.

 

For more information, Enrichment - Creating a link and Data reconciliation