Teradata Question:
Download Questions PDF

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

Answer:

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.

Download Teradata Interview Questions And Answers PDF

Previous QuestionNext Question
How many codd s rules are satisfied by teradata database?Does SDLC changes when you use Teradata instead of Oracle?