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 different table types supported by teradata?

535


What is database exceptions in teradata?

553


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?

1623


Explain the parallel data extension in teradata?

660


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

3914






Explain teradata architecture in detail with a diagram.

618


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

613


What is the purpose of using case expression in teradata?

574


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1965


Explain fastload in teradata?

603


In Teradata, what is the significance of UPSERT command?

597


During the Display time, how is the sequence generated by Teradata?

619


What is the function of parser component in teradata?

621


How can you track login parameters of users in teradata?

635


if collect stats but it show low confidence why?

1193