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 is multi insert?

618


List the logical and conditional operators that are used with teradata along with their meanings?

540


Steps to create a data model?

650


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

587


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1759






how can we analyze the locks ?

1693


Highlight the limitations of TPUMP Utility.

598


What are differences between teradata and ansi session modes in teradata?

615


How is MLOAD Client System restarted after execution?

589


What do you mean by teradata sql assistant?

581


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

619


What is stored procedure in teradata?

575


Difference between stored procedure and macro?

670


What's the difference between timestamp (0) and timestamp (6)?

622


If RDBMS is halted what will you do ?

1698