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?

  • Interview Candidate
  • 4
  • 10784

Showing Answers 1 - 4 of 4 Answers

sharanu patil

  • Feb 23rd, 2006
 

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

  Was this answer useful?  Yes

zahoorahmad

  • Apr 12th, 2006
 

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)

KP

  • May 20th, 2006
 

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...

  Was this answer useful?  Yes

tkriel

  • Nov 18th, 2008
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions