|
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 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.
|
|
|
Category |
Teradata Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 6575 users |
Added on |
8/28/2014 |
Views |
70672 |
Rate it! |
|
|
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 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. 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.
|
|
Related Questions |
View Answer |
|
How many codd's rules are satisfied by teradata database?
|
View Answer
|
|
What is basic teradata query language?
|
View Answer
|
|
What is cliques? What is Vdisk and how it will communicate with physical data storage at the time of data retrieval through AMP ?
|
View Answer
|
|
What the default privileges which get assigned ?
|
View Answer
|
|
What are the enhanced features in Teradata V2R5 and V2R6?
|
View Answer
|
|
How teradata makes sure that there are no duplicate rows being inserted when its a SET table?
|
View Answer
|
|
What is optimization and performance tuning and How does it work in practical projects. Explain with an example.
|
View Answer
|
|
What is log table? What is the use of log table?
|
View Answer
|
|
Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.
|
View Answer
|
|
What is a common data source for the central enterprise data warehouse?
|
View Answer
|
|
What is the difference between start schma and Fsldm?
|
View Answer
|
|
Which two statements are true about a foreign key?
Each Foreign Key must exist as a Primary Key.
Foreign Keys can change values over time.
|
View Answer
|
|
Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.
|
View Answer
|
|
Which two can be implemented as a centrally located logical architecture?
è operational data store
è logical data mart
|
View Answer
|
|
Does SDLC changes when you use Teradata instead of Oracle?
|
View Answer
|
|
How does indexing improve query performance?
|
View Answer
|
|
what is basic teradata query language?
|
View Answer
|
|
After creating tables dynamically in the Teardata, where is the GRANT table option usually done ? When tables are newly created, what is the default role and what the default privileges which get assigned ?
|
View Answer
|
|
What are two examples of an OLTP environment?
|
View Answer
|
|
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
|
View Answer
|