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 main components of teradata system?
Comment whether bottleneck is an error or not.
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
How would you load a very large file in teradata in general?
Highlight the differences between Primary Key and Primary Index.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
how do you manage the production space. what are the proactive methods you can take ?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What are tpump utility limitations?
What are the primary characteristics of the Teradata.
Differentiate database data and data warehouse data?
What are the steps to create a data model?
How can bottlenecks be identified?
What is the difference between global temporary tables and volatile temporary tables?
What is meant by a node?