Difference between link and reconcilliation

[Sanjana12]

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? 

[ParthaSarathy · Accepted solution]

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  >

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

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

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