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 is the use of virtual processor connectivity in teradata?
What is the maximum number of dml can be coded in a multiload script?
Explain how spool space is used.
What is a three-tier data warehouse?
Explain the parallel data extension in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is teradata and why it is used?
What are default access rights in teradata? What explicit right can be given to a user?
What do you mean by teradata sql assistant?
How do you determine the number of sessions?
What are different table types used in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What are the joins in teradata?
Explain the term 'columns' related to relational database management system?
List the logical and conditional operators that are used with teradata along with their meanings?