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
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
In the Primary Index, what is the score of AMPs that are actively involved?
What type of indexing mechanism do we need to use for a typical data warehouse?
Can you fastexport a field, which is primary key by putting equality on that key?
Explain the most common data types used in teradata?
Comment whether bottleneck is an error or not.
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the different table types supported by teradata?
What is a level of granularity of a fact table?
What are the various indexes in teradata?
What is the meaning of Caching in Teradata?
What are the available primary index types?
Explain teradata utilities. What is multiload, fast load, tpump?
Difference between star and snowflake schemas?
What is the basic syntax for teradata select statement?
