All Forums Tools
Santanu84 122 posts Joined 04/13
17 Feb 2014
Parallel Load into Single Table - TPUMP / TPT

Hi All
We have a requirement where we need to load one single table in parallel from different source tables.
Say, TableX needs to be loaded from TableA, TableB and TableC. They have different source data (Rows).
This must happen at the same time during batch load, possibly using 3 different jobs. I can think of one way to use BTEQ INSERT/SELECT and ROWHASH Locking modifier or schedule the jobs accordingly in scheduler. 
I would like to know, whether it is possible by TPT STREAM or TPUMP using Serialize option or is there any other option in TD utilities ?
 
Thanking You
Santanu

You must sign in to leave a comment.