2 Replies Latest reply on Apr 7, 2015 3:19 AM by EC91137

    How to convert Pl/SQL to informatica?

    New Member

      Hi all,

      Can any one tell how to convert pl/sql to informatica mapping?

       

      Regards,

      Deepak kumar k

        • 1. How to convert Pl/SQL to informatica?
          New Member

          Hey Deepak,

           

          I dont think so it is possible through the tool. What I'm aware is we need to understand the pl/sql coding done and design the mapping according to the requirement.

           

          Thanks

          Naresh.

          • 2. How to convert Pl/SQL to informatica?
            New Member

            Try to know your requirments, if you are looking to call PLSQL  objects via informatica that is possible, either you can use Stored  Procedure transformation and call the needed PLSQL objects, Even you can  call PLSQL components at session level prperties in Pre or Post SQL  utility available at session level.

             

            If your requirment is to re code the PLSL stuffs in  informatica then you have to understand the code and design the code in  Informatica, just to give you a small example if your PLSQL package or  procedure has explicit cursors in it you need to use a lookup  transformation with a lookup override and cache the data set in the  lookup cache same as cursor does it in PLSQL.