Why FLOAD does not support multiset tables??
Answer Posted / yuvaevergreen
Fastload utility does not support duplicate rows.
1.Since MS table supports dup rows fastload cannot load MS
table.
2.Restart logic is one of the reason. Fastload is one of the
utility which loads data in blocks(64K). During restart
Fastload sends some of the rows for the second time which
occur after a checkpoint. Due to this Fastload rejects
duplicates.
For example consider 20 rows to be loaded in a table. FL
utility is used to load the table and ckpt is 5 rows. If
restart occurs after 7th row FL may send 6 and 7th to AMPs
during the restart. This records would be considered as
duplicates and rejected.
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Explain teradata utilities. What is multiload, fast load, tpump?
What are the steps involved in the process flow of the sql statement through channel attached system?
What are the available primary index types?
What are teradata utilities?
What are the various indexes in teradata? How to use them?
How is the teradata different from oracle?
What is meant by a dispatcher?
What is oltp?
What are the available primary index types in teradata.
Mention a few of the ETL tools that come under Teradata.
Define views in teradata with syntax.
What is the primary index in teradata?
What can be achieved by using the teradata rdbms?
What are the 5 phases in a multiload utility?
What are the various indexes in teradata? Why are they preferred?