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
Describe primary index in teradata?
What is the use of stored procedures in teradata?
What are the different functions included in the server software?
What are different table types used in teradata?
What is multi insert?
What are the different design perspectives used in teradata?
Which is more efficient group by or distinct to find duplicates?
How many types of joins are there in teradata?
What is oltp?
What are the design features involved in teradata?
Write a program to show the parser component used in teradata?
What are the uses of bynets in multi-node systems?
What type of indexing mechanism do we need to use for a typical data warehouse?
How to select first n records in teradata?
what are the day to day activities of teradata DBA ?