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
Differentiate primary key and partition key?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Highlight all the modes that are present under Confidence Level.
What is the meaning of Caching in Teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is meant by a Parsing Engine?
How would you load a very large file in teradata in general?
How do you verify a complicated sql?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Can you fastexport a field, which is primary key by putting equality on that key?
What is difference between user and database in teradata?
Can you connect multiload from ab initio?
Is multi insert ansi standard?
What is the command in bteq to check for session settings ?
What is the purpose of joins in teradata and what are the available join types?
