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
If a Node is busy what are the steps you can take to avoid ?
What does Amp contain and what are all the operations that it performs?
what are the day to day activities of teradata DBA ?
Highlight the points of differences between the database and user in Teradata.
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Name the five phases that come under MultiLoad Utility.
What are some commonly used bteq scripts?
How is MLOAD Client System restarted after execution?
What is the difference between teradata and oracle?
How to identify ppi columns?
What is inner join and outer join?
Difference between stored procedure and macro?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Highlight a few of the important components of Teradata?
What happens in a conflict? How do you handle that?