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?

774


Name the five phases that come under MultiLoad Utility.

576


Explain teradata architecture?

622


How to run a query in teradata?

572


What are the updated features of teradata?

567






What are the main components of teradata system?

572


Explain the new features of teradata?

552


What is a node in teradata? Explain

591


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

601


When tpump is used instead of multiload?

612


Explain teradata vs. Redshift?

545


Differentiate database data and data warehouse data?

573


What is teradata?

631


What is the opening step in basic teradata query script?

584


What are some commonly used bteq scripts?

555