Answer / s

Yes denormalization is done performance reasons.
Normalization will keep the related data in separate
tables. In order to get the data from the tables, DB2 uses
JOIN which could be resource intensive depending on the
number of tables used in the join and the size of the table.

How is a typical db2 batch pgm executed?

0 Answers  

---

how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,

---

how can u understand the end of the table ?

1 Answers   TCS,

---

What does a deadlock mean in DB2?

0 Answers  

---

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

---

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

What is a clustering index ?

3 Answers  

---

why we create view.

5 Answers  

---