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

[Anonymous]

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.

[Anonymous · Accepted solution]

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

[Anonymous]

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

[Anonymous]

Hi,
Yes, that's right.

[Anonymous]

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