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

Answer Posted / raj

multiset table will allow duplication eventhough if you
load it into fastload it wont allow duplication

Is This Answer Correct ?    32 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

691


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

593


Explain the teradata primary index mechanics in detail with a diagram.

571


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

595


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

572






What are the things to be considered while creating secondary index?

638


What are the 5 phases in a multiload utility?

617


What are the steps to create a data model?

603


What are the different functions performed in development phase?

577


What is database exceptions in teradata?

555


When tpump is used instead of multiload?

633


how do you manage the production space. what are the proactive methods you can take ?

1480


What is the purpose of joins in teradata?

546


If RDBMS is halted what will you do ?

1711


What is dimensional modeling?

595