What is the diffrence between Multiload & Fastload interms
of Performance?

Answer Posted / shubhangi

Fastload is used to load empty tables and is very fast, can
load one table at a time.

Multiload can load at max 5 tbls at a time and can also
update and delete the data.

Fastload can be used only for inserting data, not updating
and deleting.

Is This Answer Correct ?    65 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of bynets in multi-node systems?

589


Highlight the points of differences between the database and user in Teradata.

590


What is the use of virtual processor connectivity in teradata?

569


How many types of joins are there in teradata?

547


What are the steps to create a data model?

602






What is partitioned primary index (ppi)?

572


Explain teradata vs. Redshift?

560


What are the various indexes in teradata? How to use them? Why are they preferred?

593


What do high confidence, low confidence and no confidence mean in explain plan?

590


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3000


Difference between inner join and outer join?

587


Write a program to show the parser component used in teradata?

552


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

682


What is the difference between teradata and oracle?

558


What do you mean by teradata intelliflex?

632