GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Concepts  >  OLAP

 Print  |  
Question:  What is the difference between ETL tool and OLAP tool? What are various ETL in the market? What are various OLAP tools? what is the future for both for next five years?



February 02, 2006 00:27:14 #1
 sharanu patil   Member Since: Visitor    Total Comments: N/A 

RE: what is the difference between ETL tool and OLAP t...
 

ETL is a extraction,transformation,loading tool i.e  u can extract , u can transform using different transformations available in tool  and aggreagte the data. The output of this ETL tool is used as input to OLAP tool

OLAP is online analytical process, where  u can get online reports after doing some joines,creating some cubes

ETL tools in market

1 INFORMATICA--  univeral tool ,good market

2 ABINITO --  fastest loading tool,very good market

3 DATASTAGE-- difficult work, no good market

4 BODI--  good market

5 ORACLE WAREHOUSE BUILDER--  good market

     

 

Back To Question