1 Reply Latest reply on Nov 19, 2012 7:17 AM by JeromeFr

    loading parallely

    974238
      Hi,
      I have a requirement of loading multiple files parallely using sql loader through odi.
      Currently we are not using any odi km's and we are using ODI Procedure which calls shell script/sql loader script.
      If i want to load all the files at the same time into different tables how can we do that?
      Cheers
        • 1. Re: loading parallely
          JeromeFr
          Hi,

          You can either use a Load Plan and define parallel steps ( http://www.rittmanmead.com/2011/06/odi-11g-new-mapping-and-interface-features-part-2-load-plans/ ), or use asynchronous steps in a package and add an extra step OdiWaitForChildSession : ( https://blogs.oracle.com/dataintegration/entry/parallel_processing_in_odi ).

          Hope it helps.



          Regards,

          Jerome