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.