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
Write a program to show the parser component used in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Explain BYNET.
What is teradata?
Describe primary index in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
Why does varchar occupy 2 extra bytes?
Explain amp in teradata?
What is a level of granularity of a fact table?
What are the design features involved in teradata?
Steps to create a data model?
What tools would you use for that?
What is oltp?
What are different table types used in teradata?
What's the difference between timestamp (0) and timestamp (6)?