Hi,
I am currently working in TimeXtender Data Integration (version 6766.1) and would like to view the relationships between my tables. However, when I access the “Relation Diagram,” I do not see any relationships—neither between tables across different data areas (e.g., DSA and MDW) nor between tables with lookup fields.
Is there a specific setting I need to enable to view these relationships? The data lineage for specific fields is functioning perfectly.
Best answer by Thomas Lind
Hi
The relation diagram shows the relations set up between tables. It does not just appear when you make a lookup.
If you remove the default join, it will not show in the relation diagram anymore.
So you always make the relations before dragging in the lookup field and then use the option to use the default relations in your joins.
I show it in this guide.
+5Hi
The relation diagram shows the relations set up between tables. It does not just appear when you make a lookup.
If you remove the default join, it will not show in the relation diagram anymore.
So you always make the relations before dragging in the lookup field and then use the option to use the default relations in your joins.
I show it in this guide.
+5Hi
Thank you for the tutorial, it was helpful. I am still wondering if it is possible to make a relation between tables across different data areas (e.g., DSA and MDW) ? There will not automatically be created a relation between those?
+7Hi,
Data Areas are more like functional process areas (staging, combining, final MDW, etc.). You cannot relate across Data Areas. You can, however, use schemas inside a Data Area to separate things. Inside a Data Area you can relate across schemas.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
