I have inherited work on a complex warehouse project which uses a myriad of transformations. I am perplexed as to how to find the PL/SQL procedure or the like which is represented by the transformation or connects to it. In the database there is nothing with a name that matches the name of the transformation. I have found the mappings that are represented in code but not certain transformations. A right click on the transformation does not drill into anything except labels.
Can you give an example of such transformation?