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 do you mean by tpt in teradata?
What is meant by a node?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the various indexes in teradata? Why are they preferred?
What are the joins in teradata and how many types of joins are there in teradata?
What is upsert statement in teradata?
Mention a few of the ETL tools that come under Teradata.
What are the design features involved in teradata?
How do you do backup and recovery in teradata?
what are the day to day activities of teradata DBA ?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is oltp?
What are the things to be considered while creating secondary index?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How do you define Teradata?