Interested to Buy Any Domain ? << Click Here >> for more details...
Why FLOAD does not support multiset tables??
- 3 Answers
- 14173 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 are the different softwares used with their functions in teradata?
Explain the term 'tables' related to relational database management system?
How can bottlenecks be identified?
What are the scenarios in which full table scans occurs?
What are different table types used in teradata?
Explain teradata architecture?
Why is the case expression used in teradata?
What is meant by a dispatcher?
How to find duplicates in a table?
What are the different methods ot loading a dimension table? A fact table etc?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What are the various indexes in teradata? Why are they preferred?
Comment whether bottleneck is an error or not.
List the logical and conditional operators that are used with teradata along with their meanings?
What type of indexing mechanism do we need to use for a typical data warehouse?
