Answer Posted / reddeppa reddy

select deptid, max(sal) from department table group by sal

How to performance tune reports?

1256

---

Explain what are data marts?

1194

---

Explain can a dimension table contains numeric values?

1011

---

what are relationships?

1108

---

Explain why fact table is in normal form?

1017

---

What is the difference between junk dimension and degenerated dimension?

1235

---

Can you state some of the innovations throughout history?

1028

---

What is crass reference table?

1095

---

What is the goal of optimizer?

1091

---

What is scd1 , scd2 , scd3?

1138

---

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2377

---

what is difference between drill & scope of analysis?

1166

---

What is the main difference between inmon and kimball philosophies of data warehousing?

1148

---

What are parallel querys and query hints?

2275

---

Explain what are the various reporting tools in the market?

1016

---