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

One Star

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

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.

Accepted Solutions
Employee

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

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

All Replies
Employee

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

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

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

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

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

Hi,
Yes, that's right.
One Star

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

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