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 term operational data stage (ODS) and data warehouse?
Explain, why we use the lookup transformations?
Illustrates the Replication Server in Sybase?
Explain the repository domains?
Write down a short note on the term domain constraints?
Illustrates the term Table Partitioning in detail? Answer: If you wish for to decrease page contention you do not require multiple devices. You should use multiple d
Why recursive relationships are not good? How do you solve them?
Explain the master/detail reports?
What is meant by the data modelling?
What do you understand by the term Dataset?
18,76,764
1933372 Asked
3,689
Active Tutors
1443271
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!