You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2013-08-21 10:10:17

lesanka
Member
38 posts

lesanka said:

Taxonomy in Talend

Hi

I'm new in Talend. May be someone can help me to solve the following issues:

I have hierarchical dictionary "Classifier" and simple dictionary "Goods".
Entity - Classifier
Attributes - CategoryId
                 Name
                 ParentCategoryId
For example:
           CategoryId  Name              ParentCategoryId 
                    1       Milk                  -
                    1.1    Soft milk           1
                    1.1.1 Child soft milk   1.1
                    2       Meat                 -
                    2.1    Pork                 2

Entity - Goods
Attributes - ID
                 Name
                 ClassifierCategory (FK to Classifier.CategoryId)
                 Additional

So I need:
1.   I need to make hierarchy for entity 'Classifier', but i can't deploy data model with relationship within one entity. Is it possible?
2.  I want users to add a new category (child and sibling) to the Classifier dictionary in hierarchy explorer. Is it possible? Now i can add only sibling one and have one-tier hierarchy.
3. I organaize hierarchy: child-parent, pivots - goods and classifier. So can i add a spicific attributes for each classifier category for goods' records? For example, if i add goods into "child soft milk" category, the goods' records are added automatically with special attributes such as 'possible age', 'fatness' and so on.
Another example, i have regions (or states) classifier, so i want to have a special set of attributes for each region. Also i want to have a spesific value in attribute 'Additional' (vide supra) for each region automatically.

Please, help me with that quastions. Нow can I make such structure?
I use Talend Platform for MDM v5.3.1_104014.

Thanks
Ragards

Offline

#2 2013-08-26 14:45:21

fhuaulme
Talend Team


fhuaulme said:

Re: Taxonomy in Talend

Hi,

1) yes, recursive relationships are allowed (and work). Can you elaborate a bit on the error you get?
2) I think it is possible. If you meet an issue, please file a bug on jira.talendforge.org.
3) What you want to achieve sounds like inheritance to me: you have a "Goods" entity and specializations of this entity. But this doesn't work if a "Goods" instance can change its Classifier over time.

Offline

#3 2013-08-28 11:51:49

lesanka
Member
38 posts

lesanka said:

Re: Taxonomy in Talend

Hello

Thank you for your answer.

1. Yes, you are right. At the result I could deploy data model with recursive relationships. So if I choose as a FK path PK, the error will occur. If i choose as a FK path Entity, everythig will be ok.
2. Yes, you are right i could do after creating recursive relationships.

But I have another problem. I can't add value like '1.1' as a PK and create hierarchy like i want. I asked about it in forum: http://www.talendforge.org/forum/viewtopic.php?id=31265
Can you recommend anything for me?

3. So I want to create hierarchical dictionary, there the set of attributes for records depends on the category the record have. Is it possible?

Thanks,
Regards

Offline

#4 2013-08-28 15:33:08

lesanka
Member
38 posts

lesanka said:

Re: Taxonomy in Talend

Hello

Thank you for your help. I wrote to Talend Professional Support and they helped me to solve my problem with 'dot' in PK.

Thanks,
Regards

Offline

#5 2013-09-05 10:02:29

lesanka
Member
38 posts

lesanka said:

Re: Taxonomy in Talend

Hello

But may be anyone can help me with that issue:
I want organize something like this - see screenshot: The hierarchical dictionary where childs has its own set of properties with its values.

Is it possible in Talend MDM?

Regards,
Elena
mini_116916_taxonomy.png

Offline

#6 2016-08-23 13:45:54

shri411
Member
9 posts

shri411 said:

Re: Taxonomy in Talend

Hi Lesanka,
I have a similar requirement..Can you please let me know how did you establish the recursive relationship in a single entity.?Or if you had followed any documentation ,please share that as well.

Thanks ,
Shrihari.

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy