Hello All,
Im trying to build a SQL query which will help me utilise the ODI metadata from the SNP tables in the database.
More specifically im trying to find how a field is transformed between a source and a target table.
I have found couple of links that helped me solve my issue partially but im struggling to write a SQL Query that will get me the correct output.
The links are the following:
https://www.clearpeaks.com/oracle-data-integrator-11g-ii-data-lineage/
https://community.oracle.com/thread/4279794
The first link gives the answer, if you are a user of ODI 11g.
Im using the latest version of ODI 12.2g and the query doesnt actually work