Answer Posted / vikram

Diff between RANK() and DENSE_RANK():-
------------*******-----************-------

RANK():-
---> It leaves a gap in the sequence of ranking in the
event of tie.
DENSE_RANK():-
---> It doesn't leave a gap in the sequence of ranking
in the event of tie.

EX:-
empno ename RANK DENSE_RANK
101 AAA 1 1
102 BBB 2 2
102 BBB 2 2
102 BBB 2 2
103 CCC -->5 --> 3
103 CCC 5 3
104 DDD -->7 --> 4

What is the metadata extension?

1067

---

How can you import tables from a database?

1155

---

What is meta data and system catalog?

2347

---

What are the data types present in bo?

1207

---

What is dimensional modelling?

1036

---

Explain what are the various file formats involved in reportnet?

1018

---

what are the others of "bad files" and "discard files" when using sql*loader?

2181

---

What is Active Datawarehousing?

1058

---

Store (and count) non-fact records?

982

---

Explain which are the olap tools available that are supported by oracle?

1049

---

What are the stages of datawarehousing?

1048

---

What is fact less fact table? Where you have used it in your project?

1080

---

What are various warehousing tools?

1073

---

How can we run the graph?

1133

---

What is the difference between drill through and masterdetail reports?

1244

---