Interested to Buy Any Domain ? << Click Here >> for more details...
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 16608 Views
- IBM, Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / satya
ROLLUP is used to Calculate The subtotals And Grand Total
Based On The Groupby Function.
This ROLLUP is used after the GROUP BY function.
CUBE generates a result set that represents aggregates for
all combinations of values in the selected columns.
RANK Function Is Used To Give The Ranks,But It miss Some
Ranks When Both Are Getting Same Ranks.
DENSE_RANK function Won't Give The Gaps Between The Ranks.
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Explain what are the different types of data warehousing?
what are different storage options supported by oracle ?
Which component has onread method and what it is used for?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What are the types of SCD?
How to create different types of templates?
In microstrategy, how can we direct the sql generated to use a specifc table?
Explain what are the steps to build the data warehouse?
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?
Why fact table is in a normal form?
Explain differences between star and snowflake schemas?
What are data validation strategies for data mart validation after loading process?
Is there any default username & pwd for bo designer & supervisor?
What is the purpose of Dataware Control?
Explain the differences between normalizer and normalizer transformation?
