GeekInterview.com
Series: Subject: Topic:
Question: 28 of 36

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

Asked by: Interview Candidate | Asked on: Aug 27th, 2006
Showing Answers 1 - 4 of 4 Answers
sudha

Answered On : 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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
rajajana

Answered On : Dec 7th, 2007

View all answers by rajajana

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 tablePhase1-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 phasesPhase1:It will get the import file and checks the scriptPhase2:It reads the record from the base table and store in the work tablePhase3:In this Application phase it locks the table headerPhase4:In the DML opreation will done in the tablesPhase 5: In this table locks will be released and work tables will be dropped.

  
Login to rate this answer.
SHUBH25

Answered On : Feb 15th, 2008

View all answers by SHUBH25

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 empty2. Fload performs inserts only (no updates)3. Only one target table at a time4. Must drop secondary indexes before loading and recreate them afterwardMultiload allows nonunique secondary indexes - automatically rebuilds them after loadingShubhangi

  
Login to rate this answer.
Aryan R

Answered On : Oct 26th, 2010

View all answers by Aryan R

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.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.