What is the diffrence between Multiload & Fastload interms
of Performance?
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
What are the primary characteristics of the Teradata.
What are the various indexes in teradata?
Mention a few of the ETL tools that come under Teradata.
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is bteq utility in teradata?
Explain teradata utilities?
What are default access rights in teradata? What explicit right can be given to a user?
Name the five phases that come under MultiLoad Utility.
What is oltp?
Explain PDE.
What are the steps involved in the process flow of the sql statement through channel attached system?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
How can bottlenecks be identified?
What is meant by a Least Cost Plan?
What are the newly developed features of Teradata?