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?
What are the updated features of teradata?
How to eliminate product joins in a teradata sql query?
Explain the parallel data extension in teradata?
What happens in a conflict? How do you handle that?
Differentiate database data and data warehouse data?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Explain fastload in teradata?
What are the frequently used data types in teradata?
What can be achieved by using the teradata rdbms?
what is object level locking ? where do appear this type of locking ?
Explain PDE.
What are the different table types supported by teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are default access rights in teradata?