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
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are the different functions performed in development phase?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
List the logical and conditional operators that are used with teradata along with their meanings?
How can bottlenecks be identified?
What is meant by a Virtual Disk?
How do you determine the number of sessions?
How do you set the session mode parameters in bteq?
if collect stats but it show low confidence why?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
In the Primary Index, what is the score of AMPs that are actively involved?
What is the use of teradata system software?
Describe primary index in teradata. And what are the available primary index types?
Discuss the advantages of using partitioned primary index in a query?
What happens when a node suffers a downfall?