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 is the difference between fastload and multiload?

1022


How would you load a very large file in teradata in general? What utility would you use for it? Why?

855


Describe the between keyword in teradata?

817


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

2213


What are the scenarios in which full table scans occurs?

751


What are the available primary index types in teradata.

780


Highlight the need for Performance Tuning.

788


Explain teradata architecture in detail with a diagram.

846


What is collect statistics?

774


What happens in a conflict? How do you handle that?

833


How does hashing happens in teradata?

840


What tools would you use for that?

805


Define views in teradata with syntax.

831


Why teradata is used?

776


Difference between star and snowflake schemas?

814