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
- 15549 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
What is the meaning of Caching in Teradata?
What exactly do you know about catching in teradata?
What is meant by Teradata Gateway?
Why is the case expression used in teradata?
What is real time and near real time data warehousing?
Name the five phases that come under MultiLoad Utility.
Define views in teradata with general syntax.
When tpump is used instead of multiload?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain parsing engine in teradata?
What is called partitioned primary index (ppi)?
What are normalization, first normal form, second normal form and third normal form?
What is meant by a Channel Driver?
How do you see a ddl for an existing table?
What are the functions of a Parser?
