What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 45792 Views
- Cap Gemini, Intel, I also Faced
- E-Mail Answers
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
Explain the teradata primary index mechanics in detail with a diagram.
What is smp and mpp platforms?
What is the difference between global temporary tables and volatile temporary tables?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
How do you verify a complicated sql?
Explain the term 'tables' related to relational database management system?
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
What are some primary characteristics of teradata?
What is bteq utility in teradata?
How to find duplicates in a table?
What do you mean by caching in teradata?
What is a node in teradata?
What are the string manipulation operators and functions associated with teradata?
