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

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1007

---

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

965

---

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

892

---

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

929

---

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

972

---

what is parallel query?

2043

---

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

872

---

What according to you might be the future of data warehousing?

980

---

What are various warehousing tools?

938

---

Why facts table is useful in representing the data?

957

---

What is drill-through?

939

---

How to handle multi value dimensions?

2243

---

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1332

---

Explain what is type 2 version dimension?

970

---

What is batch processing?

985

---