Interview Questions   Tutorials   Discussions   Programs   

Teradata - What is the difference between Multiload & Fastload in terms of Performance?




3096
views
asked mar September 20, 2014 06:38 AM  

What is the difference between Multiload & Fastload in terms of Performance?


           

1 Answers



 
answered By vishnoiprem   0  
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.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert