Interested to Buy Any Domain ? << Click Here >> for more details...
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 16433 Views
- IBM, Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / friend
ROLL UP IS USED TO FIND THE SUB TOTALS ,IT IS USED AFTER
GROUP BY FUNCTION,AND"CUBE"IS ALSO HAVING THE SAME
MEANING,AND RANK FUNC IS USED TO FIND THE RANKS AND IT
GIVES THE SAME RANK IF DATA HAVING SAME DATA,AND DENSE
_RANK ALSO SAME AS RANK BUT IT WILL GIVE DISTINCT RANKS IF
AT ALL IF THE DATA HAVING SAME DATA.
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
Describe a data warehouse.
What are the types of SCD?
Explain in detail abt measure objects? And what is the use of it? How to create it?
What are modeling tools available in the market?
I need a good brd and uc template?
Explain what does level of granularity of a fact table signify?
Explain what are the various transformation available?
What is an er diagram?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are the types of dimensional modeling?
Why should you put your data warehouse on a different system than your oltp system?
What is a source qualifier?
How can you set the client management?
What is an error log table in informatica occurs and how to maintain it in mapping?
How much data hold in one universe.
