Differentiate between Multiload and Fastload in Performance
Differentiate between Multiload and Fastload in terms of Performance?
Expert
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 hashingPhase2-After providing endloading commands, Amp will hashes the record and send this to the suitable AMPS.
Multiload:
This does the loading in the 5 phasesPhase1: This will get the import file and checks the scriptPhase2: This reads the record from the base table and store in the work tablePhase3: During this Application phase it locks the table headerPhase4: In the DML operation will completed in the tablesPhase 5: Inside this table locks will be released and then work tables will be dropped.
Explain the way to set the number of lines upon a page of output and the width.
Define the explaining plan and how is this used?
What are cliques?
Describe the difference between differential backups and SQL Server 2000 complete?
State the components of report studio?
What is meant by the Drill Through?
Describe why stored procedures decreased network traffic.
Explain Data Page Locking in Sybase.
Elucidate what are the basic requirements to join two sources in the source qualifier?
Explain the term power center repository?
18,76,764
1948121 Asked
3,689
Active Tutors
1413257
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!