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

Why does varchar occupy 2 extra bytes?

610


Did you write stored procedures in teradata?

619


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3912


What is the purpose of joins in teradata?

546


How many types of joins are there in teradata?

547






What are the components used in smp and massively parallel processing (mpp) machines?

599


Describe primary index in teradata. And what are the available primary index types?

547


What is the maximum number of dml can be coded in a multiload script?

621


What is TPD?

907


What are tpump utility limitations?

597


Different phases of multiload?

594


What are the steps to create a data model?

602


What is teradata?

646


What is multi insert?

628


Mention a few of the ETL tools that come under Teradata.

620