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
When tpump is used instead of multiload?
What are the string manipulation operators and functions associated with teradata?
How to view every column and the columns contained in indexes in teradata?
What are the different table types that are supported by teradata?
How would you load a very large file in teradata in general?
Highlight the need for Performance Tuning.
What is the difference between global temporary tables and volatile temporary tables?
What is the purpose of joins in teradata and what are the available join types?
What are the primary characteristics of the Teradata.
List out teradata data types?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What's the difference between timestamp (0) and timestamp (6)?
How do you do backup and recovery in teradata?
Highlight a few of the important components of Teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.