How can I get full path (including the interface name .... if possible) for an interface/package/procedure?
Suppose, an interface 'X' is created in project 'A' under folder 'D', which is a sub-folder of folder 'C', which is a sub-folder of folder 'B'. Then I want to get the full path for the interface 'X' which I can paste to another application, say MS Word.
Is ther any way?
Thanks and regards,
Its possible , run an SQL report against your work repository, start with SNP_POP table, then recursive (connect by) loop up to the top through SNP_FOLDER, alternatively just alias SNP_FOLDER for how ever many levels you think you are using and join them up appropriately.
Thanks Alastair. I do not have access to the repository at the moment. So is there anything within the tool itself?
Hi Mate - didnt spot your username when I replied :-)
As Bhabani says - the built in report might help but your left looking through PDF's.
Otherways might be : ODIConsole via (web app) if you have it configured, or possibly the ODI-OBIEE Lineage reporting via OBIEE , again if you have it set up!
It asks for a PDF Reader. But you can also define that in the ODI user parameters.
Or you can unthick the box to open it directly after the creation and open it by yourself from your Explorer. It should have been generated correctly at the chosen path.