Hi All,
I am preparing a query in ODI metadata DB (using SNP tables) to get the ODI Package details. I am stuck and one place. Below is my case:
- I get package name and its other info in SNP_PACKAGE table. ---This is done
- I get Package step details in SNP_STEP table. ---This is done
- I have variables in package which are having value as SQL select statement (100+ lines). I am not able to figure out SNP table/view where I can get the exact value for those variables assigned in package. Those variables does not have any value when they were created. The SQL statement is assigned as value for those variables in a package only. ---Stuck here
Can somebody please help me on how can I get the package variable assigned value is stored in ODI metadata or SNP tables.
I am using ODI 12.2.1.4