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.
1 ACCEPTED SOLUTION

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
4 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