Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 47553 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
How you will check the version of teradata?
What is the difference between fastload and multiload? Which one is faster?
What is the purpose of using case expression in teradata?
What is a dimension table?
What does Amp contain and what are all the operations that it performs?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the design features involved in teradata?
Explain the term 'row' related to relational database management system?
how do you manage the production space. what are the proactive methods you can take ?
What is basic teradata query language?
Explain fallback in teradata?
What is a sparse index?
What are the joins in teradata and how many types of joins are there in teradata?
How would you load a very large file in teradata in general?
What is partitioned primary index (ppi)?
