Interested to Buy Any Domain ? << Click Here >> for more details...
How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
- 2 Answers
- 15440 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / n
Sel HASHAMP(HASHBUCKET(HASHROW(PRIMARY_INDEX_COLUMNS)))
AS AMP_NO,
COUNT(*)
From DATABASENAME.TABLE_NAME
GROUP BY 1;
| Is This Answer Correct ? | 30 Yes | 2 No |
Post New Answer View All Answers
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What can be achieved by using the teradata rdbms?
what are the day to day activities of teradata DBA ?
What is oltp?
If RDBMS is halted what will you do ?
Explain the most common data types used in teradata?
Highlight the advantages of PPI(Partition Primary Index).
Explain BYNET.
How can you track login parameters of users in teradata?
How is MLOAD Client System restarted after execution?
Explain the term 'database' related to relational database management system?
What is the use of fallback?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What do you mean by teradata intelliflex?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
