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
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What exactly do you know about catching in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Highlight the need for Performance Tuning.
What are the various reporting tools in the market?
What happens when a node suffers a downfall?
How to run a query in teradata?
What do you mean by fastexport in teradata?
What are different table types used in teradata?
Explain the new features of teradata?
Explain the term 'primary key' related to relational database management system?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is bteq utility in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
List the logical and conditional operators that are used with teradata along with their meanings?