Interested to Buy Any Domain ? << Click Here >> for more details...
Why FLOAD does not support multiset tables??
- 3 Answers
- 14000 Views
- TCS, Tesco, I also Faced
- E-Mail Answers
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
Differentiate primary key and partition key?
How do you determine the number of sessions?
What is a node in teradata?
What do you mean by ttu in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Explain fastload in teradata?
What is the purpose of joins in teradata and what are the available join types?
Explain vproc in teradata?
What is difference between user and database in teradata?
What is TPD?
What is dimensional modeling?
what are the uses of fact table and dimension table in banking project?
What are the multiload utility limitations?
What are the components used in smp and massively parallel processing (mpp) machines?
Differentiate database data and data warehouse data?
