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 differences between teradata and ansi session modes in teradata?
What is logical data model?
What are the steps involved in the process flow of the sql statement through channel attached system?
If a Node is busy what are the steps you can take to avoid ?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are the available primary index types in teradata.
Name the five phases that come under MultiLoad Utility.
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are different table types used in teradata?
What is the difference between fastload and multiload?
What are the uses of bynets in multi-node systems?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Difference between inner join and outer join?
Why is the case expression used in teradata?
What is the difference between fastload and multiload? Which one is faster?
