Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
How to find source datastores that are used in the creation of the model

Hi dears
let say my model as 'X'. the model 'X' are using some table that names are 'a', 'b' and 'c'. these tables through some join, filters and etc. are filling the model 'X'. is there any table which store these relations like the below
Target------ Source
X ----------- a
X ----------- b
X----------- c
I need some data like this to know my models are using where and it is created based on which tables?
Answers
-
ODI already has a graphic solution where you can visualize where a specific table is being used. You can check it under "Used To Populate", "Populated By" and "Used by". If you need something more specific, then you would need to query the ODI repository (SNP tables). In the link below there is one example of how to build such queries:
https://devepm.com/2020/02/26/odi-hidden-gems-snp-tables-query-to-get-executed-code-example/
Hope it helps!