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

Answer Posted / yuvaevergreen

In terms of speed, fastload would be suitable than mload for
loading an empty table.
But when it comes to multiset tables, mload would be a
better option.
Mload allows use of aggregated values whereas fastload does not.

Is This Answer Correct ?    14 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various etl tools in the market?

586


What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

547


What are different table types used in teradata?

587


What are normalization, first normal form, second normal form and third normal form?

628


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

673






What is meant by a Highest Cost Plan?

623


Explain teradata architecture?

634


What is a sparse index?

632


What is a dimension table?

610


What are the things to be considered while creating secondary index?

633


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2352


What is spool space?

602


Explain parsing engine in teradata?

592


Which is faster fastload or multiload?

597


What is smp and mpp platforms?

527