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
What is the command in bteq to check for session settings ?
how can we analyze the locks ?
What is inner join and outer join?
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 different functions performed in development phase?
Can we collect statistics on table level?
What are some commonly used bteq scripts?
How many sessions of MAX is PE capable of handling at a particular time?
What is oltp?
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain teradata vs. Redshift?
Name the five phases that come under MultiLoad Utility.
What do you mean by fastexport in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
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?