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 basic teradata query language?
Can we collect statistics on table level?
The transaction exceeded the maximum number of rowhash locks allowed
Highlight the differences between Primary Key and Primary Index.
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How do you eliminate duplicates?
What are normalization, first normal form, second normal form and third normal form?
what is use of PI(primary index) AND SI(secondary index)
what is DYNAMIC SQL in TD?
What is use of compress in terdata?Explain?
Explain fastload in teradata?