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 multiload utility limitations?
Comment whether bottleneck is an error or not.
Discuss the advantages of using partitioned primary index in a query?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Explain amp in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is meant by a Highest Cost Plan?
What are the different design perspectives used in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What happens in a conflict? How do you handle that?
What is multi insert?
What exactly do you know about catching in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
Highlight the differences between Primary Key and Primary Index.
What does Amp contain and what are all the operations that it performs?
