Why FLOAD does not support multiset tables??
Answer Posted / 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 |
Post New Answer View All Answers
What are the functions involved in shared information architecture?
What are the steps involved after the disk manager passes the request?
Explain the advantages of partitioned primary index in a query?
What are the design features involved in teradata?
Explain the teradata primary index mechanics in detail with a diagram.
In general, how do you optimze any sql in teradata?
Is multi insert ansi standard?
Why do you get spool space errors? How do trouble-shoot them?
What is bteq script in teradata?
What is spool space?
Steps to create a data model?
What is meant by a Clique?
What is teradata and why it is used?
Highlight the limitations of TPUMP Utility.
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?