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 |
What is meant by MATCHTAG in multiload utility?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What are tpump utility limitations?
Highlight all the modes that are present under Confidence Level.
Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
What is the purpose of joins in teradata and what are the available join types?
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?
What are the functions of a teradata dba?
What is node? How many nodes and amps used in your previous project?
Differentiate primary key and partition key?
Describe primary index in teradata. And what are the available primary index types?
What is collect State in Teradata ? what it use and how it works??