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
Go To First  |  Previous Question  |  Next Question 
 OLAP  |  Question 5 of 11    Print  
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?

  
Total Answers and Comments: 3 Last Update: May 20, 2006     Asked by: Aditya 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 23, 2006 00:27:14   #1  
sharanu patil        

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


 
Is this answer useful? Yes | No
April 12, 2006 20:06:52   #2  
zahoorahmad Member Since: April 2006   Contribution: 7    

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

ETL is 2 step before OLAP

1) Sources (source of data they can b different data bases)

2) ETL (u extractl transforms and load the data )

3) Data stagging or busines subjective( then u store and stag the data)

4) OLAP (through olap u visualize different data differently)


 
Is this answer useful? Yes | No
May 20, 2006 13:33:00   #3  
KP        

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

Yes, OLAP is after ETL.  Its how user's querry the data that the ETL loaded, to do analytical work; Sales Analysis for example.

OLAP Vendors: Microstrategy, BO (IE: Crystal), Hyperion...


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape