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
What are some primary characteristics of teradata?
What is the maximum number of dml can be coded in a multiload script?
What is a clique?
Can we collect statistics on table level?
Where is teradata rdbms used?
What are the scenarios in which full table scans occurs?
Explain fallback in teradata?
What do you mean by teradata intelliflex?
Explain the new features of teradata?
Describe primary index in teradata?
What is a sparse index?
What are the design features involved in teradata?
What are the available join types in teradata?
Explain and compare pros and cons of snow flake schemas?
What is spool space?