Tpump and Load failure

[Henshin1]

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?

Also,
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 alot!

 

[madanjs]

1.If the load fails, can it pick up again and continue from where it failed?
Yes,it can pick up the load based on CHECKPOINT frequency...
Robust ON
It keeps duplicates from being re-inserted into the table in the event of a restart..
2.if u were to remove the IGNORE DUPLICATES line from my tpump script,
no issue of set table...
for multiset,it can effect..