Answer Posted / lakshmi

SELECT d.dname,e.sal from emp e,dept d where e.deptno=d.deptno
group by dname

How to add a number to a macro variable?

992

---

Explain dimensional modelling?

985

---

What needs to be done when the database is shutdown?

1026

---

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

962

---

How are the dimension tables designed?

1001

---

Explain what are the various reporting tools in the market?

983

---

Explain why dimenstion tables are denormalized in nature?

920

---

Explain which columns go to the fact table and which columns go the dimension table?

928

---

Why we use repository connectivity?

981

---

How to define a cube??

931

---

what are different storage options supported by oracle ?

2092

---

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1099

---

Could any one explain me how to create cascading prompts?

1070

---

Can we take backup when the database is opened?

1051

---

In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

2243

---