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 are types of partition primary index (ppi) in teradata?
Explain vproc in teradata?
Explain PDE.
what are the uses of fact table and dimension table in banking project?
Where is teradata rdbms used?
What are the joins in teradata and how many types of joins are there in teradata?
What is collect statistics?
Explain the term 'columns' related to relational database management system?
How many codd's rules are satisfied by teradata database?
How can bottlenecks be identified?
How do you create tables? Exact syntax, and create profiles, users in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are the updated features of teradata?
Different phases of multiload?
What are the steps involved after the disk manager passes the request?
