Interested to Buy Any Domain ? << Click Here >> for more details...
Why FLOAD does not support multiset tables??
- 3 Answers
- 14032 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
What is upsert statement in teradata?
Define views in teradata with syntax.
Why teradata is used?
In general, how do you optimze any sql in teradata?
How would you load a very large file in teradata in general?
What is a node in teradata?
What are the various reporting tools in the market?
How many tables can you join in v2r5?
What are the different functions performed in development phase?
In the Primary Index, what is the score of AMPs that are actively involved?
What happens when a node suffers a downfall?
What are the functions of a Parser?
How can bottlenecks be identified?
What is the use of fallback?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
