Doubt in Using the Stored Procedures in the Output Card

srinivas123 · Post by **srinivas123** » Wed Nov 15, 2006 1:22 am

I am using a wtx map which has one input card for reading a text file and seven output card for persisting into the Database. Each of the output card calls a DB2 Stored Procedure. These stored procedures inserts into various tables. For the input file with millions of records..the map takes more time to complete..More than 2 hours. Is there any solution to tune up the performance. Is it possible to run the map in threads. I am using Command Server. Kindly revert me back with ur comments[/b]

janhess · Post by **janhess** » Wed Nov 15, 2006 3:07 am

If you can split your input file into a number of files you can run multiple occurrences of the map.