Answer Posted / harsh sugandhi

select dname, max(sal) from dept group by dname;

List down some of the real time data-warehousing tools?

955

---

What is the difference between filter and lookup transformation?

1080

---

What are diagrams?

1027

---

Explain what is difference between query studio and report studio?

969

---

What is data mart in data warehouse?

923

---

What are the other names given to data warehousing?

1078

---

How much data hold in one universe.

983

---

Explain swot analysis?

1148

---

What is a Decision Tree Algorithm?

4993

---

What are snapshots? What are materialized views & where do we use them?

1030

---

What is the difference between olap and oltp?

1036

---

How can we run the graph? What is the procedure for that?

936

---

What are the different types of data warehousing?

937

---

What is latest version of power center / power mart?

1036

---

Why should you put your data warehouse on a different system than your oltp system?

967

---