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?
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.