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 difference between fastload and multiload?
What is teradata and why it is used?
What is meant by a Clique?
What is the maximum number of dml can be coded in a multiload script?
How do you define Teradata?
What are teradata utilities?
Explain the teradata primary index mechanics in detail with a diagram.
What is the command in bteq to check for session settings ?
Difference between stored procedure and macro?
What is upsert statement in teradata?
Highlight the points of differences between the database and user in Teradata.
what is sysdba and sysdbc ? which has high priority ?
What are the various etl tools in the market?
What are the components used in smp and massively parallel processing (mpp) machines?
What are the various reporting tools in the market?
