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
How can bottlenecks be identified?
How can you track login parameters of users in teradata?
What exactly do you know about catching in teradata?
What are the various indexes in teradata?
How do you verify a complicated sql?
What is teradata?
Explain teradata utilities?
Explain the term 'tables' related to relational database management system?
What is a level of granularity of a fact table?
What happens in a conflict? How do you handle that?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are types of partition primary index (ppi) in teradata?
how many modules are there in telecome domain?how to explain the architecture?
What are the enhanced features in teradata v2r5 and v2r6?
How will you solve the problem that occurs during update?
