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

Compare to FastLoad Multiload is slower But loads into
Multiple Tables with different DML Operations.Multiload
suports maximum 20 DML Operations.multiload slowdown
operation of AMP.There is no Trasand Journal
Overhead.Multiload Maximum 15 Multiload scripts run at a
time.Multiload supports duplicates also

FastLOad loads data into empty tables.it loads only one
table at a time.compare to all utiities it is faster.it
can't load the duplicates(either multiset NUPI).it loads
the error data into error tables.fastload fastload does
insert operation between Begin and endloading statements.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

3416


What exactly do you know about catching in teradata?

1075


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

1021


Highlight the need for Performance Tuning.

1150


What are the various reporting tools in the market?

1113


What happens when a node suffers a downfall?

1180


How to run a query in teradata?

1141


What do you mean by fastexport in teradata?

1042


What are different table types used in teradata?

1092


Explain the new features of teradata?

1089


Explain the term 'primary key' related to relational database management system?

1087


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1154


What is bteq utility in teradata?

1023


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

2238


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

1039