explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
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
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Database in use is oracle?
Explain what are the advantages data mining over traditional approaches?
explain about dirty dimension?
Explain which columns go to the fact table and which columns go the dimension table?
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain the main difference between inmon and kimball philosophies of data warehousing?
Explain what is fact less fact table? Where you have used it in your project?
What is a data profile?
What is a functional dependency f said to be minimal?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain how to export mappings to the production environment?
What is core dimension?
Explain why should you put your data warehouse on a different system than your oltp system?
List down some of the real time data-warehousing tools?
What is a core dimension?