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
- 15343 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Adding to the above,
hashrow gives the unique row hash (23 bit value) for any
value given as a parameter.
hashbucket gives the bucket value (16 bit) for any hashrow.
hashmap gives the ampno for the hashbucket.
Since, PI must be defined for any table, this hashing
function can be used to determine the ampno and the no of
rows in the amps.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How many codd's rules are satisfied by teradata database?
What are the string manipulation operators and functions associated with teradata?
How is MLOAD Client System restarted after execution?
How can you track login parameters of users in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
what are the day to day activities of teradata DBA ?
What do you mean by teradata intelliflex?
What is the purpose of upsert command?
Can you connect multiload from ab initio?
How to Extract data from multiple legacy systems?
What are the design features involved in teradata?
Steps to create a data model?
Explain Teradata performance tuning and optimization?
Highlight the points of differences between the database and user in Teradata.
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
