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
Explain the parallel data extension in teradata?
How do you determine the number of sessions?
Difference between stored procedure and macro?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the components used in smp and massively parallel processing (mpp) machines?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is TPD?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the available join types in teradata?
What are the multiload utility limitations?
What are the various indexes in teradata?
Highlight the need for Performance Tuning.
What are default access rights in teradata?
What are tpump utility limitations?
