Why Fload doesn’t support multiset table?

Answer Posted / rajneesh

FastLoad support Multiset table but does not support the
duplicate rows.
Multiset tables are tables that allow duplicate rows.
When FastLoad finds the duplicate rows it discards it. Fast
Load can load data into multiset table but will not load
the duplicate rows.

Is This Answer Correct ?    30 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain teradata vs. Redshift?

566


What is meant by a Virtual Disk?

586


Explain the new features of teradata?

580


Highlight a few of the advantages that ETL tools have over Teradata.

625


What does Amp contain and what are all the operations that it performs?

596






How to identify ppi columns?

660


What is meant by a Clique?

594


Syntax for case when statement?

618


what is object level locking ? where do appear this type of locking ?

3121


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

580


Difference between inner join and outer join?

593


Explain the types of join supports by teradata?

596


Explain fallback in teradata?

615


How to select first n records in teradata?

619


What is the opening step in basic teradata query script?

606