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 5 phases in a multiload utility?
What is node? How many nodes and amps used in your previous project?
Difference between star and snowflake schemas?
What is spool space?
How do you define Teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the different functions performed in development phase?
Which is faster fastload or multiload?
Explain teradata vs. Redshift?
how many modules are there in telecome domain?how to explain the architecture?
Name the five phases that come under MultiLoad Utility.
How to find duplicates in a table?
What happens when a node suffers a downfall?
How many types of joins are there in teradata?
Define views in teradata with general syntax.