Differentiate between Multiload and Fastload in Performance

Question

Differentiate between Multiload and Fastload in terms of Performance?

Answer 1

If you wish to load, empty table then you use the fastload, so this will very helpful than the mutiload. Since fastload performs the loading of the data within 2phase and this no require a work table for loading the data, so this is faster as well as this follows the below steps to load the data inside the table:

Phase1-This moves all the records to the entire AMP first without any hashing
Phase2-After providing endloading commands, Amp will hashes the record and send this to the suitable AMPS.

Multiload:

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