What is the diffrence between Multiload & Fastload interms
of Performance?

Answer Posted / tdguy

FLOAD is faster than MLOAD for an empty SET table.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various indexes in teradata? Why are they preferred?

741


Describe primary index in teradata?

758


In general, how do you optimze any sql in teradata?

764


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

825


Can we collect statistics on multiple columns?

751


What are the functions involved in shared information architecture?

812


What are the steps involved in the process flow of the sql statement through channel attached system?

853


List the logical and conditional operators that are used with teradata along with their meanings?

745


In Teradata, how do we Generate Sequence?

779


What is the primary index in teradata?

800


What is called partitioned primary index (ppi)?

744


What is the command in bteq to check for session settings ?

858


What is smp and mpp platforms?

711


What is the purpose of joins in teradata?

777


What is stored procedure in teradata?

768