Answers

Question and Answer:

  Home  Teradata

⟩ What is the difference between Multiload and Fastload interms of Performance?

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.

 153 views

More Questions for you: