What is the diffrence between Multiload & Fastload interms
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
|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
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 ?||11 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 ?||8 Yes||2 No|
Answer / yuvaevergreen
For a given empty SET table and input file with same no of
rows, FLOAD is faster than MLOAD.
FLOAD--PHASES--2;MAXIMUM TABLES--1;DML STATEMENTS SUPPORTED-
-INSERT;DDL STATEMENTS SUPPORTED--CREATE,DROP;ERROR TABLES
TO BE DEFINED--YES;WORK TABLES TO BE DEFINED--NO;
MLOAD--PHASES--5;MAXIMUM TABLES--5;DML STATEMENTS SUPPORTED-
-INSERT,DELETE,UPDATE,UPSERT;DDL STATEMENTS SUPPORTED--
DROP;ERROR TABLES TO BE DEFINED--YES;WORK TABLES TO BE
|Is This Answer Correct ?||4 Yes||0 No|
Answer / tdguy
FLOAD is faster than MLOAD for an empty SET table.
|Is This Answer Correct ?||4 Yes||1 No|
Aborted in Phase 2 data acquistion completed in fastload?
How is Teradata in current market?
Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q
What is a pseudo key? What is its use???
Why Multiload does not supports USI and supports NUSI?
which option is used to restart the fastexport script ?
what is single value and Multivalue ?
how do you manage the production space. what are the proactive methods you can take ?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
what are the file sizes in your project?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
can we join volatile table with general table an global temporary table with general table ?