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
Can we collect statistics on table level?
What are the advantages of teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is meant by Teradata Gateway?
What is the use of virtual processor connectivity in teradata?
What are aggregate tables? How do you design them using teradata?
What are the different design perspectives used in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
If RDBMS is halted what will you do ?
Explain how spool space is used.
What are the various indexes in teradata? Why are they preferred?
What tools would you use for that?
Different phases of multiload?
what are the uses of fact table and dimension table in banking project?
