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
What is partitioned primary index (ppi)?
What is teradata and why it is used?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Explain BYNET.
What is oltp?
What are the various indexes in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is the syntax for case when statement?
What is meant by a dispatcher?
Explain the term 'database' related to relational database management system?
What interface is used to connect to windows based applications?
Which is faster fastload or multiload?
Explain the advantages of partitioned primary index in a query?