as like Row id in the Oracle what is the unique identifier in Teradata apart from primaryindex hash value,
i want to know the as per this comment ( rowid is the combination of rowhash and uniqueness value) how to fetch the rowid through Query.
Depends on how many partitions you have. it you have less then 65535 then your rowkey is going to be
2 bytes + 4bytes for the Row Hash + 4 bytes for the uniqueness value
More then 65535 partitions and it uses 8 bytes for the internal partition number