sudha

• Sep 27th, 2006

 

Fast Load: to load empty tables at high speed.

MLoad: to insert,update and delete up to 5 different tables or views.

rajajana

 Profile Answers by rajajana 

• Dec 7th, 2007

 

If you want to load, empty table then you use the fastload, so it will very usefull than the mutiload..because fastload performs the loading of the data in 2phase..and it noneed a work table for loading the data.., so it is faster as well as it follows the below steps to load the data in the table

Phase1-It moves all the records to all the AMP first without any hashing 
Phase2-After giving endloading command, Amp will hashes the record and send it to the appropriate AMPS .

Multiload:

It does the loading in the 5 phases
Phase1:It will get the import file and checks the script
Phase2:It reads the record from the base table and store in the work table
Phase3:In this Application phase it locks the table header
Phase4:In the DML opreation will done in the tables
Phase 5: In this table locks will be released and work tables will be dropped.

SHUBH25

 Profile Answers by SHUBH25 

• Feb 15th, 2008

 

As the name suggests Fasload is faster than multiload, and whenever required to load an empty table fastload should be preferred.
However, Fastload has some limitations.

To perform Fload:
1. Target table must be empty
2. Fload performs inserts only (no updates)
3. Only one target table at a time
4. Must drop secondary indexes before loading and recreate them afterward

Multiload allows nonunique secondary indexes - automatically rebuilds them after loading

Shubhangi

Aryan R

 Profile Answers by Aryan R 

• Oct 26th, 2010

 

Fastload
1) Loads one table at a time
2) It does not load duplicate data.
3) Table should be empty.
4) Runs 2 phases.
5) It does not run in modes.
a) Import mode.
b) Delete mode.
6) It needs 2 error tables.
7) It does not support NUSI table
8) It applies Access lock on target Table during loading.

Multiload
1) Loads up to 5 tables at a time.
2) Does not mind loading duplicate data.
3) Loads the data into the Table whether it can be either empty or full.
4) Runs 5 phases.
5) It runs in 2 modes.
6) It needs 2 error tables, 1 restart log table and 1 work table.
7) It supports NUSI table loading loading.
8) It applies write lock on target Table table during loading.

kusuma

• Jun 15th, 2015

 

how to resolve no more spool space issue?

Bhargav

• May 22nd, 2016

 

What is Performance issues we considered while Execute the large amount data(Load the data from Files to Teradata Database)

CHetan

• Jun 8th, 2017

 

If you are looking at high volume data in that case Fastload would give better performance. since Fastload would work in 2 phases whereas Multiload will have 5 for the same. But we are looking at low volume data then you have TPump as another option.