ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Warehouse General
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
 Question Submitted By :: Jakki
I also faced this Question!!     Rank Answer Posted By  
 
  Re: explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
Answer
# 1		 
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 ?    1 Yes 1 No
Friend
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
What is source qualifier?  1
Can you explain how analysis service works?  1
What is up date strategy and what are th options for update strategy?  2
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?  2
1.WHAT IS DATA MART ? HCL1
what are the types of dimension tables  6
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I IBM1
What is the difference between a data warehouse and a data mart?  7
Difference between ODS and Staging TCS1
What is the capacity of power cube?  1
What is IQD file?  1
which automation tool is used in data warehouse testing?  1
How can you define a transformation? What are different types of transformations in Informatica? TCS3
What is staging area?  6
What is confirmed dimension?  3
What is the "junk dimension"? Give with examples?  3
what is the use of surrogate key in businessobjects  1
How to use the tool Ontobulider  1
what is the difference between DSS and ODS ? Satyam2
What is difference between Business Objects and Hyperion Essbase? Please help me  1
 
For more Data Warehouse General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com