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

Database in use is oracle?

1005

---

Explain what are the advantages data mining over traditional approaches?

1082

---

explain about dirty dimension?

1072

---

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

869

---

Explain what are the various methods of getting incremental records or delta records from the source systems?

914

---

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

921

---

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

870

---

What is a data profile?

909

---

What is a functional dependency f said to be minimal?

981

---

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1008

---

Explain how to export mappings to the production environment?

918

---

What is core dimension?

996

---

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

866

---

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

915

---

What is a core dimension?

1014

---