Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How does rows store in Teradata

Answer Posted / amish ojha

applying hashing algorithm to the PI system gets the ROW
HASH ,that will be searched in the HASH BUCKET to get the
desired AMP ,thereafter by adding uniqueness value to row
hash value the row ID is obtained and then it gets stored
in AMP ..


PI-->ROW HASH ---> HASH BUCKET(MAP)--> AMPno

ROWID = ROW HASH + UNIQUENESS ID

where actually the row is stored

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain storage manager?

997


diff b/w inter process and in process

2065


What is difference between clustered, non-clustered and unique index?

1071


How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1910


Explain entity type?

981


1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?

2178


If the master device is full, how do I make the master database bigger?

962


How default key is different from primary key?

1026


How heap is implemented in database?

1152


What is meant by distributed system?

981


What is the Lock Based Protocol used for?

1065


Explain natural key?

1105


What does new grouping sets enables you to do?

1019


What will happen non-clustered index will be created on clustered index?

1029


What do you mean by foreign key and primary key?

1026