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 to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Can we collect statistics on multiple columns?
What are the various indexes in teradata? How to use them?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is the basic syntax for teradata select statement?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are tpump utility limitations?
Steps to create a data model?
What are the different table types that are supported by teradata?
Explain teradata architecture?
Did you write stored procedures in teradata?
How many tables can you join in v2r5?
What is the purpose of using case expression in teradata?
How to eliminate product joins in a teradata sql query?
Difference between star and snowflake schemas?