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 / kumar

Multiload can at max 5 tables with non unique secondary
indexes on them. where as in fastload u cannot have
secondary indexes on the table.

In multiload you can insert,update or delete data in
already populated tables whereas in fastload the target
table should be empty.

Multiload works in 5 phases whereas fastload works in two
phases.

If we want to load data into an empty table then fastload
is best option as compared to multiload.

Is This Answer Correct ?    54 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If a Node is busy what are the steps you can take to avoid ?

2416


What does Amp contain and what are all the operations that it performs?

1006


what are the day to day activities of teradata DBA ?

5825


Highlight the points of differences between the database and user in Teradata.

1109


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1955


Name the five phases that come under MultiLoad Utility.

988


What are some commonly used bteq scripts?

1012


How is MLOAD Client System restarted after execution?

1155


What is the difference between teradata and oracle?

1027


How to identify ppi columns?

1180


What is inner join and outer join?

1111


Difference between stored procedure and macro?

1173


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3373


Highlight a few of the important components of Teradata?

1030


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

1048