How to find source datastores that are used in the creation of the model

User_TKCE4

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?

Rodrigo Radtke Souza

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!