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


Please Help Members By Posting Answers For Below Questions

What are the main components of teradata system?

574


Comment whether bottleneck is an error or not.

610


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

363


How would you load a very large file in teradata in general?

553


Highlight the differences between Primary Key and Primary Index.

605






What is the particular designated level at which a LOCK is liable to be applied in Teradata?

587


how do you manage the production space. what are the proactive methods you can take ?

1469


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?

1608


What are tpump utility limitations?

586


What are the primary characteristics of the Teradata.

579


Differentiate database data and data warehouse data?

577


What are the steps to create a data model?

589


How can bottlenecks be identified?

567


What is the difference between global temporary tables and volatile temporary tables?

627


What is meant by a node?

609