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
Steps to create a data model?
Explain and compare pros and cons of snow flake schemas?
What is meant by a Channel Driver?
Why teradata is used?
What is spool space? Why do you get spool space errors?
What happens in a conflict? How do you handle that?
What is the use of fallback?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Why does varchar occupy 2 extra bytes?
When tpump is used instead of multiload?
How to eliminate product joins in a teradata sql query?
Highlight the differences between Primary Key and Primary Index.
How do you define Teradata?
What are the main components of teradata system?
What are the different table types supported by teradata?
