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

What are normalization, first normal form, second normal form and third normal form?

1052


Different phases of multiload?

999


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

951


what is object level locking ? where do appear this type of locking ?

3492


How can you track login parameters of users in teradata?

1191


What is the function of parser component in teradata?

1082


What are the functions performed by bynet?

1039


What are teradata utilities?

1109


What is bteq utility in teradata?

968


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

1731


Differentiate primary key and partition key?

979


What do you mean by fastexport in teradata?

999


What is primary index and secondary index?

1028


Steps to create a data model?

1129


Define views in teradata with general syntax.

1025