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
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Highlight the advantages of PPI(Partition Primary Index).
How to identify ppi columns?
What is the function of parser component in teradata?
What is the primary index in teradata?
What are different table types used in teradata?
Explain the new features of teradata?
In general, how do you optimze any sql in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is meant by a Virtual Disk?
What is the use of virtual processor connectivity in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Difference between multiload and tpump?
