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
How is MLOAD Teradata Server restarted after execution?
Difference between inner join and outer join?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is smp and mpp platforms?
What are the joins in teradata?
Explain the term 'columns' related to relational database management system?
Explain parsing engine in teradata?
What is meant by a Parsing Engine?
What are normalization, first normal form, second normal form and third normal form?
How to load specific no.of records using bteq, or fastload,or multiload
Explain Teradata performance tuning and optimization?
What is the use of having index on table?
What does Amp contain and what are all the operations that it performs?
What are aggregate tables? How do you design them using teradata?
What are differences between teradata and ansi session modes in teradata?