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

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1703


What are different table types used in teradata?

590


how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1284


Explain the term 'columns' related to relational database management system?

552


What is the maximum number of dml can be coded in a multiload script?

623






There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

647


Describe the between keyword in teradata?

615


How do you define Teradata?

609


What are the various reporting tools in the market?

619


What interface is used to connect to windows based applications?

588


How can bottlenecks be identified?

587


In Teradata, how do we Generate Sequence?

609


How many codd's rules are satisfied by teradata database?

666


What are the various etl tools in the market?

587


Syntax for case when statement?

615