I am receiving files which contains more than 500 vendors information. depending on the vender name we need to get some additional data from oracle table. If we put a loop on the vender name and perform select adapter service, then for each vendor webmethods will connect to database. Its like connecting to database more than 500 times. This is not a best practice, Because of performance and connectivity issues.
I need a solution which takes all the vendor names and select the data from database in a single transaction. webmethods should get all the information in a single transaction.
Please provide me valuble solutions, Thanks.