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
Explain PDE.
What is a level of granularity of a fact table?
Explain and compare pros and cons of snow flake schemas?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is meant by a node?
What is the purpose of joins in teradata and what are the available join types?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Explain the term 'columns' related to relational database management system?
What are default access rights in teradata?
How does hashing happens in teradata?
Define views in teradata with syntax.
Explain amp in teradata?
How is MLOAD Client System restarted after execution?
Did you write stored procedures in teradata?
What are the scenarios in which full table scans occurs?
