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




Answers were Sorted based on User's Feedback



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

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

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

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
phases.

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

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

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




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

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

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

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

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

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

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

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
DEFINED--YES;

Is This Answer Correct ?    4 Yes 0 No

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

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

what is identity columns in teradata

2 Answers   Wipro,


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

0 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,


What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,


Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

6 Answers   IBM,






Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  


IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

2 Answers   Infosys, Cap Gemini, IBM,


Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?

4 Answers  


suppose one Cylinder split data blocks are moved from where?

1 Answers  


What are the types of tables in Teradata

22 Answers   Cognizant, Infosys, Cap Gemini,


why should we go Teradata over Oracle,what is the main differences?

4 Answers   TCS,


How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?

2 Answers   IBM,






Categories