Answer / 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

What are the differences between Database Trigger and Integrity constraints ?

2 Answers   Synergy,

---

What is a trace file?

0 Answers   Tech Mahindra,

---

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)?

0 Answers  

---

What is relational database with example?

0 Answers  

---

How to do performance tunning a database in DB2 V8.2 UDB in linux

0 Answers  

---

---

Why merge statement is used inside the database?

0 Answers   ADITI,

---

How many types of normalization? What is the use of it?

0 Answers   Accenture,

---

what is difference between delete and truncet ?

7 Answers   Fidelity,

---

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

0 Answers  

---

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

0 Answers  

---

What advantages does DBMS have over traditional file systems?

0 Answers   ABB, Infogain,

---

Can we have a function Overloading with same number of arguments but with different return types of function

8 Answers   CybAge, Wipro,

---