Answer Posted / bharath
after you restart the fast load job,
Therefore, some number of rows will be sent to the AMPs
again because the restart starts on the next record after
the value stored in the checkpoint. Hence, when a restart
occurs, the first row after the checkpoint and some of the
consecutive rows are sent a second time. These will be
caught as duplicate rows after the sort. This restart logic
is the reason that FastLoad will not load duplicate rows
into a MULTISET table. It assumes they are duplicates
because of this logic.
Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What are the things to be considered while creating secondary index?
Explain fastload in teradata?
what is sysdba and sysdbc ? which has high priority ?
What is the use of fallback?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Why managing the data is important?
Describe primary index in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
Can we collect statistics on table level?
What is teradata? What are some primary characteristics of teradata?
Explain teradata architecture?
What is the purpose of joins in teradata?
What is meant by a Clique?
What does sleep function does in fast load?
What is bteq script in teradata?