What is the diffrence between Multiload & Fastload interms
of Performance?
Answer Posted / gaurav
Fast load v/s Multi Load
1) FL insert data into empty table ML insert/update/delete
data in populated tables
2) FL one table ML upto 5 tables.
3) FL loads into empty table ML loads into Populated table.
4) FL no SI allowed in ML NUSI is allowed.
5) FL is 2 step ML is 5 step.
6) FL no multiset tables allowed ML multiset table is allowed.
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What are the functions involved in shared information architecture?
Explain the term 'primary key' related to relational database management system?
What is teradata? Also, list out some of the primary characteristics of teradata.
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are teradata utilities?
What are the components used in smp and massively parallel processing (mpp) machines?
What is called partitioned primary index (ppi)?
What are the advantages of teradata?
What happens when a node suffers a downfall?
What is meant by a Least Cost Plan?
How do you verify a complicated sql?
What are the different functions included in the server software?
How is MLOAD Client System restarted after execution?
What are the steps to create a data model?