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.

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.

Answer / raj

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

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.

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.

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.

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;

Answer / tdguy

FLOAD is faster than MLOAD for an empty SET table.

I want to write one query How to get Matched records and unmatched records in table?

4 Answers   TCS,

What are the multiload utility limitations?

0 Answers  

Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance

2 Answers  

What is partitioned primary index (ppi)?

0 Answers  

Why Multiload does not supports USI and supports NUSI?

4 Answers  

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

0 Answers  

any one answer me how they can analyzing the project using data ware housing?

0 Answers  

any one pls tell me what are the table names in banking project?

2 Answers  

What is smp and mpp platforms?

0 Answers  

The transaction exceeded the maximum number of rowhash locks allowed

1 Answers   Wipro,

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

0 Answers  

Why do Hash joins usually perform better than Merge Joins?

1 Answers