Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / tdguy
-->Fload does not support multiset tables because it does
not support duplicate rows.
-->Fload does not allow duplicate roww, because of the
restart logic.Whenever a failure occurs and restart occurs,
fload identifies the checkpoint and sends some records to
the amps which were already sent. This is because, failure
occurs at checkpoint rarely. Assume checkpoint is to be
taken every 10 rows and the failure occurs exactly while
processing at the 14th row. When Fload is restarted, it
identifies the checkpoint and sends the rows starting from
11th row. However the rows 11 to 14 will be captured as
duplicates and just counted. This can be seen in the stats
of Fload.
TOTAL DUPLICATE ROWS = 0
Though these rows are not captured, these rows are just
noted. This is the reason, Fload does not support duplicate
rows.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What are the different softwares used with their functions in teradata?
Highlight the points of differences between the database and user in Teradata.
Explain the parallel data extension in teradata?
What is the use of fallback?
Explain the term 'tables' related to relational database management system?
Syntax for case when statement?
How would you load a very large file in teradata in general?
Is multi insert ansi standard?
Explain parsing engine in teradata?
What is meant by Teradata Gateway?
What is bteq utility in teradata?
Describe primary index in teradata. And what are the available primary index types?
What is dimensional modeling?
What is basic teradata query language?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
