what is differences between Fastload and Multiload as per DBA aspect ?



what is differences between Fastload and Multiload as per DBA aspect ?..

Answer / vennela12

DBA want to check the table structure regarding load..

In Fload case table structure should have set table and index should be UPI

In Mload case table structure should have any table and any index

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More Teradata Interview Questions

What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,


What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

0 Answers  


What are tpump utility limitations?

0 Answers  


Highlight all the modes that are present under Confidence Level.

0 Answers  


Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???

1 Answers   IBM,


What is the purpose of joins in teradata and what are the available join types?

0 Answers  


1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?

3 Answers  


What are the functions of a teradata dba?

0 Answers  


What is node? How many nodes and amps used in your previous project?

0 Answers  


Differentiate primary key and partition key?

0 Answers  


Describe primary index in teradata. And what are the available primary index types?

0 Answers  


What is collect State in Teradata ? what it use and how it works??

3 Answers   TCS,


Categories