INTERVIEW QUESTIONS DATABASE TERADATA DETAILS

Question: What is the difference between Multiload & Fastload interms of Performance?

Answer: If you want to load empty table then you use the fastload, so it will very useful than the multiload because fastload performs the loading of the data in 2 phase and it no need 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<br><br>Phase1-It moves all the records to all the AMP first without any hashing <br>Phase2-After giving endloading command, Amp will hashes the record and send it to the appropriate AMPS .<br><br>Multiload:<br><br>It does the loading in the 5 phases<br>Phase1:It will get the import file and checks the script<br>Phase2:It reads the record from the base table and store in the work table<br>Phase3:In this Application phase it locks the table header<br>Phase4:In the DML opreation will done in the tables<br>Phase 5: In this table locks will be released and work tables will be dropped.

If you want to load empty table then you use the fastload, so it will very useful than the multiload because fastload performs the loading of the data in 2 phase and it no need 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<br><br>Phase1-It moves all the records to all the AMP first without any hashing <br>Phase2-After giving endloading command, Amp will hashes the record and send it to the appropriate AMPS .<br><br>Multiload:<br><br>It does the loading in the 5 phases<br>Phase1:It will get the import file and checks the script<br>Phase2:It reads the record from the base table and store in the work table<br>Phase3:In this Application phase it locks the table header<br>Phase4:In the DML opreation will done in the tables<br>Phase 5: In this table locks will be released and work tables will be dropped. Source: CoolInterview.com

In terms of speed, fastload would be suitable than mload for
loading an empty table.
But when it comes to multiset tables, mload would be a
better option.
Mload allows use of aggregated values whereas fastload does not. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question