Interested to Buy Any Domain ? << Click Here >> for more details...
Why FLOAD does not support multiset tables??
- 3 Answers
- 14055 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 a sparse index?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Why does varchar occupy 2 extra bytes?
What are the available join types in teradata?
What is spool space?
What are the main components of teradata system?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Explain and compare pros and cons of snow flake schemas?
Explain how spool space is used.
What are the steps involved in the process flow of the sql statement through channel attached system?
What are the available primary index types in teradata.
Give the sizes of SMALLINT, BYTEINT and INTEGER.
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What tools would you use for that?
What is the use of teradata system software?
