Interested to Buy Any Domain ? << Click Here >> for more details...
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 16611 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
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What are the possible data marts in retail sales?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Explain what are the various transformation available?
What are fundamental stages of data warehousing?
How can we schedule the graph in unix?
What is normalization, first normal form, second normal form, third normal form?
What are the tools available for etl?
Explain about core dimension, balanced dimension, and dirty dimension?
what are the other factors of the database on which the loading performance depend?
What is data warehouse architecture?
Is union transormation is active transformation?
What is the metadata extension?
What are target types on the server?
ware house management system is used?
