Tpump and Loading

Tools
Enthusiast

Tpump and Loading

Hi all,

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?

Thanks alot for any help.
Tags (1)
2 REPLIES
Enthusiast

Re: Tpump and Loading

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.
Enthusiast

Re: Tpump and Loading

I just wanted to add to this question.

If I were to remove the IGNORE DUPLICATES line from my tpump script, would a failed load be able to continue where it failed?
And is this also the same for Set and Multiset tables?

Thanks again.