Why Fload doesn’t support multiset table?

Answer Posted / srinu

Fast Load will load the Data Fastly,
Mean Concurrently,Bulk Insert.
Internally TeraData server will Create
Bulk insert DML statament
(Like: insert into Table1 as sel * from Table2
with data)
For Fast Performence it will not support the
duplicate values,Refential Intigrity,,,,


If u know the Better answer compare to this let me Know,
srinu.srinuvas@gmail.com

Is This Answer Correct ?    0 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the commands to make a new table, change a table and remove a table in teradata?

601


how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1268


What is the multi-insert?

593


Highlight the advantages of PPI(Partition Primary Index).

553


Explain the term 'tables' related to relational database management system?

586






What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

639


What is meant by a Highest Cost Plan?

611


Explain the term 'database' related to relational database management system?

560


What type of indexing mechanism do we need to use for a typical data warehouse?

604


Explain the parallel data extension in teradata?

642


Can we collect statistics on table level?

590


What are the uses of client software involved in teradata?

523


What are default access rights in teradata?

611


What is node? How many nodes and amps used in your previous project?

660


What is upsert statement in teradata?

601