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
Why are oltp database designs not generally a good idea for a data warehouse?
Explain fallback in teradata?
How do you see a ddl for an existing table?
What are the advantages of teradata?
What is the purpose of using case expression in teradata?
What is a sparse index?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the multiload utility limitations?
In BTEQ, how are the session-mode parameters being set?
Can we collect statistics on table level?
What is dimensional modeling?
What are the scenarios in which full table scans occurs?
What are the steps involved after the disk manager passes the request?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are different table types used in teradata?
