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

utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN

2 Answers   Accenture,

---

What is the importance of database partitioning?

0 Answers  

---

hOW TO LOAD SOURCE INTO TARGET 2 TIMES?(INFORMATICA)

2 Answers  

---

Which three commands cause a transaction to end?

0 Answers   3i Infotech,

---

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

0 Answers  

---

Explain transaction manager?

0 Answers  

---

what is tkprof tool and how it is used???

0 Answers   Genpact,

---

What is a database example?

0 Answers  

---

Write the major components of a Database Management System?

3 Answers  

---

Explain storage manager?

0 Answers  

---

What is a database string?

0 Answers  

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

0 Answers   Miracle Software,

---