Answer Posted / naveen

SELECT
D.DEPTNO,D.DNAME,MAX(E.SAL)
FROM
EMP E,DEPT D
WHERE
D.DEPTNO=E.DEPT.NO
GROUP BY D.DEPTNO,D.DNAME

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

954

---

Explain what is the metadata extension?

1020

---

What is surrogate key? Where we use it? Explain with examples.

1014

---

How we are using this function?

1099

---

What is the difference between mapping parameter & mapping variable in data warehousing?

963

---

What is a linked cube?

987

---

Could any one explain me how to create cascading prompts?

1054

---

Explain meta data?

1012

---

what are relationships?

1022

---

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

1021

---

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

1009

---

What are the design methods of data warehousing?

932

---

What is the function of surrogate key in data warehousing?

1053

---

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1001

---

what are the all possible features supported modify stage?

2118

---