What is the diffrence between Multiload & Fastload interms
of Performance?
Answer Posted / yuvaevergreen
In terms of speed, fastload would be suitable than mload for
loading an empty table.
But when it comes to multiset tables, mload would be a
better option.
Mload allows use of aggregated values whereas fastload does not.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
Which is more efficient group by or distinct to find duplicates?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Explain teradata utilities?
What is stored procedure in teradata?
What is the primary index in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is meant by a Parsing Engine?
How is the teradata different from oracle?
What is the opening step in basic teradata query script?
What are the joins in teradata and how many types of joins are there in teradata?
What is spool space?
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 functions of a teradata dba?
What is the purpose of using case expression in teradata?
What are the frequently used data types in teradata?