topic Re: [resolved] How to implement many-to-many relationship? in Talend Data Catalog

[resolved] How to implement many-to-many relationship?

Anonymous — Sat, 16 Nov 2024 13:28:48 GMT

Hi.
I know how to implement many to one relationship using foreign key.
But I need to implement many to many relationship. For example, Recipe consist of many Ingredients and Ingredient may by in many Recipes. How to do this in Talend MDM?
Thank you.

Re: [resolved] How to implement many-to-many relationship?

Anonymous — Thu, 01 Apr 2010 15:17:41 GMT

Hi,
You can use a multi-occurrence attribute : in your example, use a multi-occurrence attribute in Recipe that relates to an Ingredient.
regards

Re: [resolved] How to implement many-to-many relationship?

Anonymous — Thu, 01 Apr 2010 17:54:51 GMT

> RecipeType
> Ingredients
> Annotations
> Foreign Key: Ingredient/Id
Is this right?
Thank you.

Re: [resolved] How to implement many-to-many relationship?

Anonymous — Fri, 02 Apr 2010 09:12:18 GMT

Hi,
Yes, that's right.

Re: [resolved] How to implement many-to-many relationship?

Anonymous — Thu, 30 Jun 2011 14:34:38 GMT

Hi
Any chance we could get a short demo on how we populate this using TIS?
thanks