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
What are the various etl tools in the market?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What are different table types used in teradata?
What are normalization, first normal form, second normal form and third normal form?
What is node? How many nodes and amps used in your previous project?
What is meant by a Highest Cost Plan?
Explain teradata architecture?
What is a sparse index?
What is a dimension table?
What are the things to be considered while creating secondary index?
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
What is spool space?
Explain parsing engine in teradata?
Which is faster fastload or multiload?
What is smp and mpp platforms?