GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Concepts  >  OLAP
Go To First  |  Previous Question  |  Next Question 
 OLAP  |  Question 5 of 12    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: 4 Last Update: November 18, 2008     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 | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
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
November 18, 2008 11:18:30   #4  
tkriel Member Since: November 2008   Contribution: 1    

RE: 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?
ETL Tools Extract Transform and Load data into a database. There are many tools on the market for ETL (Business Objects Informatica Data Flux etc).

OLAP analyzes the data inthe database.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape