Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1149


What are the different functions performed in development phase?

1073


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2472


List the logical and conditional operators that are used with teradata along with their meanings?

999


How can bottlenecks be identified?

1011


What is meant by a Virtual Disk?

1124


How do you determine the number of sessions?

1059


How do you set the session mode parameters in bteq?

1099


if collect stats but it show low confidence why?

1683


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1105


In the Primary Index, what is the score of AMPs that are actively involved?

1068


What is the use of teradata system software?

1032


Describe primary index in teradata. And what are the available primary index types?

999


Discuss the advantages of using partitioned primary index in a query?

947


What happens when a node suffers a downfall?

1120