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
What do you mean by teradata intelliflex?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is dimensional modeling?
What are the different functions included in the server software?
How many sessions of MAX is PE capable of handling at a particular time?
What exactly do you know about catching in teradata?
any one answer me how they can analyzing the project using data ware housing?
What are the various indexes in teradata? How to use them? Why are they preferred?
how many modules are there in telecome domain?how to explain the architecture?
How many codd's rules are satisfied by teradata database?
Name the five phases that come under MultiLoad Utility.
What are the scenarios in which full table scans occurs?
Did you write stored procedures in teradata?
What is multi insert?
what are the uses of fact table and dimension table in banking project?