I wanted to ask a question regarding Tpump loading into a Set table. If the load fails, can it pick up again and continue from where it failed? Or does there have to be some form of clean up and restarting of the job?
Also, is there any difference between using tPump to load data into a Set and Multiset table?
Tpump and other load utilities have various restart options. If you specify the ROBUST option with Tpump, it will do fine-grained checkpointing and be fully restartable with either set or multiset tables.
Regardless of the load method, loads into a multiset table are faster since there is one less constraint to check.