Interested to Buy Any Domain ? << Click Here >> for more details...
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 is the multi-insert?
Explain BYNET.
What is primary index and secondary index?
What is meant by a Clique?
Syntax for case when statement?
What is stored procedure in teradata?
How to view every column and the columns contained in indexes in teradata?
What is the maximum number of dml can be coded in a multiload script?
What is the purpose of joins in teradata and what are the available join types?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the different softwares used with their functions in teradata?
Highlight the differences between Primary Key and Primary Index.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is teradata and why it is used?
What are default access rights in teradata? What explicit right can be given to a user?
