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 ?