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
How do you see a ddl for an existing table?
What is meant by Teradata Gateway?
How to find duplicates in a table?
What are the steps to create a data model?
Highlight the limitations of TPUMP Utility.
What is the purpose of joins in teradata and what are the available join types?
Explain parsing engine in teradata?
What do you mean by teradata intellicloud?
What do you mean by fastexport in teradata?
Why does varchar occupy 2 extra bytes?
What is TPD?
What is the syntax for case when statement?
What is the difference between global temporary tables and volatile temporary tables?
Describe primary index in teradata. And what are the available primary index types?
Explain the teradata primary index mechanics in detail with a diagram.
