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
what is the difference between etl tool and olap tools
 Question Submitted By :: G Ruban
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the difference between etl tool and olap tools
Answer
# 1
etl tool means extract,transform and load the data into the 
ware house.based on this data by using olap tool we can 
generate reports
 
Is This Answer Correct ?    1 Yes 0 No
B Siva Pratap
 
  Re: what is the difference between etl tool and olap tools
Answer
# 2
hai

  In my case ETL tool is used to extract data from diffrent 
sources,and make the data consistent and transformed to DWH.
olap tools are nothing but a DWH.
 
Is This Answer Correct ?    1 Yes 0 No
Uzval_vee
[Not Yet]
 
 
 
  Re: what is the difference between etl tool and olap tools
Answer
# 3
ETL Tool is used to Extrand Transform and Load data into 
your Dataware house e.g. Informatica. OLAP Tool is nothing 
but to design your Dataware house (more in logical) e.g. 
Oracle Warehouse builder (can be use for ETL) or Siebel 
Analytics (more for Dahsboard purpose but you can design 
your DW)
 
Is This Answer Correct ?    1 Yes 0 No
Harshad
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
What is staging area?  6
What is MDX? TCS1
how do you use commit frequencies? how does it affect loading performance?  1
What is Time Series algorithm in data mining?  1
What is the difference between an ODS and a W/H?  1
what is a hot file, why we need in datawarehousing, where we used in general Thomson1
wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.  1
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ? Oracle3
What is query panel?  1
What is the capacity of power cube?  1
what is data validation strategies for data mart validation after loading process  1
When should one use an MD-database (multi-dimensional database) and not a relational one?  1
1.WHAT IS DATA MART ? HCL1
Tell me one example for multi valued dimension or bridge table? TCS1
What is source qualifier?  1
What is difference between a connected look up and unconnected look up?  1
4.Explain Snowflkeschema ? HCL1
DWH architecture?  3
What is ?Data Warehousing??  2
What is Bulk Insert?  3
 
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