Doubt in Using the Stored Procedures in the Output Card
-
- Participant
- Posts: 2
- Joined: Sat Nov 19, 2005 9:40 pm
Doubt in Using the Stored Procedures in the Output Card
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]