Why FLOAD does not support multiset tables??
Answers were Sorted based on User's Feedback
Answer / adi
Fload will allow multiset table. But there is no advantage
of loading multiset table using fload, becuase fload does
not insert duplicate rows. If we try to load multiset table
using fload with duplicate rows, they fload inserts
distinct rows into the target table and the duplicate row
count displayed under second error table.
Is This Answer Correct ? | 18 Yes | 1 No |
Answer / 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 |
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Is multi insert ansi standard?
What are the things to be considered while creating secondary index?
How to find duplicates in a table?
Explain the term 'primary key' related to relational database management system?
What's the difference between timestamp (0) and timestamp (6)?
Describe primary index in teradata?
What do you mean by tpt in teradata?
I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata
what are the file sizes in your project?
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
What are the various reporting tools in the market?