Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / amit sethiya
I believe Fastload silently discards duplicate rows. They don't go to the error table.
Many of the differences between FastLoad and MultiLoad are due to the fact that MultiLoad loads by way of an intermediate work table, whereas Fastload loads directly into the target table, which is sorted later. The sorting process automatically removes duplicate rows. The records that MultiLoad loads the work table during the acquisition phase are not exact images of the target rows. They contain sequence numbers that are generated by the client module. If the acquisition phase is restarted, the client may resend rows that were previously sent after the last checkpoint, as is the case with Fastload. However, only duplicate records with matching sequence numbers are discarded when the work table is sorted at the end of the acquisition phase. Duplicate records with non-matching sequence numbers are retained.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is spool space? Why do you get spool space errors?
Why does varchar occupy 2 extra bytes?
What do you mean by teradata intellicloud?
What is the difference between teradata and basic rdbms?
What are the uses of bynets in multi-node systems?
What are the various indexes in teradata? How to use them?
How is MLOAD Client System restarted after execution?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How to view every column and the columns contained in indexes in teradata?
Comment whether bottleneck is an error or not.
Differentiate primary key and partition key?
What is teradata?
Explain BYNET.
What are the functions of a teradata dba?
