What is the diffrence between Multiload & Fastload interms
of Performance?

Answers were Sorted based on User's Feedback

Answer / shubhangi

Fastload is used to load empty tables and is very fast, can
load one table at a time.

Multiload can load at max 5 tbls at a time and can also
update and delete the data.

Fastload can be used only for inserting data, not updating
and deleting.

Is This Answer Correct ?    65 Yes 8 No

Answer / kumar

Multiload can at max 5 tables with non unique secondary
indexes on them. where as in fastload u cannot have
secondary indexes on the table.

In multiload you can insert,update or delete data in
already populated tables whereas in fastload the target
table should be empty.

Multiload works in 5 phases whereas fastload works in two

If we want to load data into an empty table then fastload
is best option as compared to multiload.

Is This Answer Correct ?    54 Yes 6 No

Answer / raj

multiset table will allow duplication eventhough if you
load it into fastload it wont allow duplication

Is This Answer Correct ?    32 Yes 1 No

Answer / yuvaevergreen

In terms of speed, fastload would be suitable than mload for
loading an empty table.
But when it comes to multiset tables, mload would be a
better option.
Mload allows use of aggregated values whereas fastload does not.

Is This Answer Correct ?    14 Yes 2 No

Answer / gaurav

Fast load v/s Multi Load
1) FL insert data into empty table ML insert/update/delete
data in populated tables
2) FL one table ML upto 5 tables.
3) FL loads into empty table ML loads into Populated table.
4) FL no SI allowed in ML NUSI is allowed.
5) FL is 2 step ML is 5 step.
6) FL no multiset tables allowed ML multiset table is allowed.

Is This Answer Correct ?    10 Yes 2 No

Answer / 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 ?    7 Yes 2 No

Answer / yuvaevergreen

For a given empty SET table and input file with same no of
rows, FLOAD is faster than MLOAD.

Is This Answer Correct ?    3 Yes 0 No

Answer / tdguy

FLOAD is faster than MLOAD for an empty SET table.

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More Teradata Interview Questions

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers   IBM,

what is the difference between filter and router transmissions

2 Answers  

I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,

in teradata level primary in table level allows duplicates why?

1 Answers   TCS,

how can we analyze the locks ?

0 Answers   HP,

A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 Answers  

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

0 Answers  

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  

what is object level locking ? where do appear this type of locking ?

0 Answers  

Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me

25 Answers   TCS,

what is the default character set in teradata,,?

2 Answers   IBM, TCS,

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

3 Answers   CTS, Lexicon,