Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 47475 Views
- Cap Gemini, Intel, I also Faced
- E-Mail Answers
Answer Posted / kumar
Multiload can at max 5 tables with non unique secondary
indexes on them. where as in fastload u cannot have
secondary indexes on the table.
In multiload you can insert,update or delete data in
already populated tables whereas in fastload the target
table should be empty.
Multiload works in 5 phases whereas fastload works in two
phases.
If we want to load data into an empty table then fastload
is best option as compared to multiload.
| Is This Answer Correct ? | 54 Yes | 6 No |
Post New Answer View All Answers
Explain the new features of teradata?
How can you track login parameters of users in teradata?
how can we analyze the locks ?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
List out some of the primary characteristics of teradata.
What are the steps involved after the disk manager passes the request?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are the different table types that are supported by teradata?
Which is faster fastload or multiload?
What is the difference between teradata and basic rdbms?
What is bteq utility in teradata?
if collect stats but it show low confidence why?
What is teradata and why it is used?
What is the use of stored procedures in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
